pg_stat_database – select * from depesz;

Waiting for PostgreSQL 14 – Add pg_stat_database counters for sessions and session time

On 17th of January 2021, Magnus Hagander committed patch:

Add pg_stat_database counters for sessions and session time
 
This add counters for number of sessions, the different kind of session
termination types, and timers for how much time is spent in active vs
idle in a database to pg_stat_database.
 
Internally this also renames the parameter "force" to disconnect. This
was the only use-case for the parameter before, so repurposing it to
this mroe narrow usecase makes things cleaner than inventing something
new.
 
Author: Laurenz Albe
Reviewed-By: Magnus Hagander, Soumyadeep Chakraborty, Masahiro Ikeda
Discussion: https://postgr.es/m/b07e1f9953701b90c66ed368656f2aef40cac4fb.camel@cybertec.at

Continue reading Waiting for PostgreSQL 14 – Add pg_stat_database counters for sessions and session time

What’s happening in my database?

Lately at least two people on irc asked questions similar to “how do I know how many queries there are in database, per second?“.

So, let's see what we can find out.

Continue reading What's happening in my database?

Waiting for 9.2 – deadlock counter

On 26th of January, Magnus Hagander committed patch:

Adds a counter that tracks number of deadlocks that occurred in
each database to pg_stat_database.
 
Magnus Hagander, reviewed by Jaime Casanova

Continue reading Waiting for 9.2 – deadlock counter

=$
|

Tag: pg_stat_database

Waiting for PostgreSQL 14 – Add pg_stat_database counters for sessions and session time

What’s happening in my database?

Waiting for 9.2 – deadlock counter