PostgreSQL で実行中のクエリを確認する方法のメモ。
pg_stat_activity テーブルで実行中のクエリを参照することができます。
# select * from pg_stat_activity;
datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type
-------+----------+------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-----------------+---------------------+--------+-------------+--------------+----------+---------------------------------+------------------------------
5 | postgres | 3983 | | 10 | postgres | psql | 127.0.0.1 | | 58884 | 2025-02-18 23:24:17.79372+09 | 2025-02-18 23:26:01.543685+09 | 2025-02-18 23:26:01.543685+09 | 2025-02-18 23:26:01.543687+09 | | | active | | 246389 | | select * from pg_stat_activity; | client backend
5 | postgres | 4527 | | 10 | postgres | psql | 127.0.0.1 | | 40056 | 2025-02-18 23:25:47.587781+09 | 2025-02-18 23:25:58.352106+09 | 2025-02-18 23:25:58.352106+09 | 2025-02-18 23:25:58.352109+09 | Timeout | PgSleep | active | | 246389 | | select pg_sleep(1000); | client backend
| | 1145 | | | | | | | | 2025-02-18 23:08:03.235239+09 | | | | Activity | AutovacuumMain | | | | | | autovacuum launcher
| | 1146 | | 10 | postgres | | | | | 2025-02-18 23:08:03.235243+09 | | | | Activity | LogicalLauncherMain | | | | | | logical replication launcher
| | 1121 | | | | | | | | 2025-02-18 23:08:03.193927+09 | | | | Activity | CheckpointerMain | | | | | | checkpointer
| | 1122 | | | | | | | | 2025-02-18 23:08:03.194386+09 | | | | Activity | BgwriterHibernate | | | | | | background writer
| | 1143 | | | | | | | | 2025-02-18 23:08:03.234863+09 | | | | Activity | WalWriterMain | | | | | | walwriter
