ying_lu@xxxxxxxxxxxxxxx (Ying Lu) writes: > Greetings, > > I have a question about how to see current processes running under > postgreSQL. > > "show processlist" will display DB, command, time, State, etc under MySQL: > > | Id | User | Host | db | Command | Time | > *State * | *Info* > | 21 | admin | server1:40898 | test | *Query* | 104 | > Copying to tmp table | INSERT INTO test (SELECT ... ... > > > May I know which commands to display similar current running > commands/states under PostgreSQL please? The nearest rough equivalent would be the contents of the system table pg_catalog.pg_stat_activity. This will only contain actual query information if the database is configured to collect statistics on queries, so it's possible for the field current_query to be left blank... -- (format nil "~S@~S" "cbbrowne" "acm.org") http://www.ntlug.org/~cbbrowne/sap.html Rules of the Evil Overlord #78. "I will not tell my Legions of Terror "And he must be taken alive!" The command will be: ``And try to take him alive if it is reasonably practical.''" <http://www.eviloverlord.com/> ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
