On Mon, Jun 06, 2005 at 11:22:23AM -0400, Ying Lu wrote: > 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?
You're looking for something like SELECT * FROM pg_stat_activity; Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
