Difference between revisions of "Pg stat activity"
Jump to navigation
Jump to search
(22 intermediate revisions by 4 users not shown) | |||
Line 1: | Line 1: | ||
+ | {{lowercase}} | ||
+ | select count(*) from [[pg_stat]]_activity where query like '[[autovacuum]]:%'; | ||
+ | count | ||
+ | ------- | ||
+ | 0 | ||
+ | (1 row) | ||
− | + | {{pg_stat_activity}} | |
+ | |||
+ | SELECT [[pg_terminate_backend]](__pid__) from pg_stat_activity; | ||
== Related terms == | == Related terms == | ||
+ | * <code>select [[pg_terminate_backend]](procpid) from pg_stat_activity where datname = 'your-db';</code> | ||
* <code>[[DataFileRead]]</code> | * <code>[[DataFileRead]]</code> | ||
* [[PostgreSQL statistics collector]] | * [[PostgreSQL statistics collector]] | ||
* <code>[[select count]]</code> | * <code>[[select count]]</code> | ||
+ | * <code>[[pg_cancel_backend]]</code> | ||
== See also == | == See also == | ||
+ | * {{pg_stat}} | ||
+ | * {{VACUUM}} | ||
* {{PostgreSQL}} | * {{PostgreSQL}} | ||
[[Category:PosgreSQL]] | [[Category:PosgreSQL]] |
Latest revision as of 10:22, 5 May 2023
select count(*) from pg_stat_activity where query like 'autovacuum:%'; count ------- 0 (1 row)
SELECT * FROM pg_stat_activity; SELECT * FROM pg_stat_activity WHERE datname = 'dbname'; SELECT * FROM pg_stat_activity WHERE datname = 'dbname' and state = 'active'; SELECT usename, application_name, client_addr, client_hostname, state FROM pg_stat_activity; SELECT pg_terminate_backend(__pid__) from pg_stat_activity;
SELECT pg_terminate_backend(__pid__) from pg_stat_activity;
Related terms[edit]
select pg_terminate_backend(procpid) from pg_stat_activity where datname = 'your-db';
DataFileRead
- PostgreSQL statistics collector
select count
pg_cancel_backend
See also[edit]
pg_stat, pg_stat_activity, pg_stat_statements, pg_stat_replication, pg_stat_io
- VACUUM: PostgreSQL VACUUM, Autovacuum,
pg_database, pg_stat_activity
, Redshift VACUUM - PostgreSQL:
pg_dump, pg_restore
,pgAdmin, pg_config, psql, pg_ctl, pg_isready, initdb
, Role, Schema, DBeaver, Navicat, DataGrip, OmniDB,Adminer
, docker-compose.xml PostgreSQL, PostgreSQL version, PostgreSQL logs,postgresql.conf
,pg_hba.conf, $HOME/.pg_service.conf
, Create database (PostgreSQL), Create user,createdb
,GRANT
,pg_stat
, PostgreSQL VACUUM, EXPLAIN,pg stat activity
, Autovacuum, ALTER DATABASE, PostgreSQL statistics collector, Shared buffers, EXPLAIN (PostgreSQL),EXPLAIN ANALYZE
, Bitmap scan,EXPLAIN VERBOSE
,EXPLAIN VERBOSE (PostgresSQL)
,WAL
,ALTER USER
,CREATE ROLE, CREATE USER
,\du
,show users
,\l
, The Statistics Collector, pganalyze,cron.schedule
, Master,pg_tables
, PostgreSQL replication,CREATE, SET
, TOAST, PgBouncer, Restore DB, Index, meta-commands, Table, foreign table, Schema, Sequence, Views, materialized view, Table Partitioning, monitoring, PostgreSQL System Administration Functions, PostgreSQL extension, privileges, logging, PGTune, PostgreSQL parameter tunning, PostgreSQL modules, pgbench, PostgreSQL users, catalogs
Advertising: