Questions tagged [pg-stat-activity]

pg_stat_activity is a PostgreSQL table that contains statistics about running queries in the DBMS.

Filter by
Sorted by
Tagged with
0
votes
1answer
64 views

Why is pg_stat_activity.query_start null for almost all queries? [closed]

Why is pg_stat_activity.query_start null for almost all queries? What is the meaning of a NULL query_start field?
0
votes
1answer
140 views

What does pg_stat_activity.xact_start mean for autovacuum threads?

If I see something like: db=> SELECT datname,pid,state, (now() - query_start)::interval, query FROM pg_stat_activity where state != 'idle' and query like 'autovacuum%'; datname | pid | state | ...
2
votes
1answer
809 views

pg_stat_statements causing DB to run out of memory

I enabled pg_stat_statements on an AWS RDS postgres 9.6.3 instance with 30GB RAM. We got the error message below in postgres log, and an event saying OS killed DB server process due to excessive ...
4
votes
1answer
935 views

PostgreSQL: Run EXPLAIN on all queries in pg_stat_activity

I am investigating high load on a PostgreSQL database on RDS. As a part of the investigation, I'm running the following query: SELECT now()-query_start, state, query FROM pg_stat_activity ORDER BY 1 ...
0
votes
2answers
660 views

pg_stat_activity entries with no corresponding process on the client

If I see an entry in pg_stat_activity for a client_addr:client_port combination where there is no process bound to that port on the indicated client, what does that mean? Just that the client process ...