Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

PostgreSQL pg_stat_activity status

Active: query is running and session is hitting every threshold time,
Idle in transaction: query is completed,and waiting for commit, session is hitting every threshold period.
Idle in transaction (aborted): last or some statement was aborted due to network or syntax error (consider here some statement executed succefully but some one only got issue),Similar to idle in transaction, except one of the statements in the transaction caused an error.
Idle: session timeout and query executed and query has been committed
Disabled:If track activities is disabled in this backend.
So Before​ closing session you have to issue commit otherwise work_mem will not release that particular session


Popular posts from this blog

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

PostgreSQL Database startup / shutdown /restart

How to Enable/Disable autovacuum on PostgreSQL

ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated ORA-01262: Stat failed on a file destination directory Linux-x86_64 Error: 2: No such file or directory

PostgreSQL Pgbadger Installation On Linux