Skip to content

Tag Archives: postgresql.conf

PostgreSQL Query Monitoring

15-Feb-09

postgres=# select * from pg_stat_activity; datid | datname | procpid | usesysid | usename | current_query | query_start | backend_start | client_addr | client_port ——-+———-+———+———-+———-+—————+——————————-+——————————-+————-+————- 10793 | postgres | 3443 | 10 | postgres | <IDLE> | 2009-02-15 07:36:14.272725-08 | 2009-02-15 07:36:14.272521-08 | | -1 (1 row) If you do not have stats_command_string set to [...]