Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [pg-stat-activity]

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

0
votes
1answer
29 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
113 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
688 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
912 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
621 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 ...