CREATE EXTENSION pg_stat_monitor; SELECT pg_stat_monitor_reset(); pg_stat_monitor_reset ----------------------- (1 row) SELECT 1 AS num; num ----- 1 (1 row) SELECT query,application_name FROM pg_stat_monitor ORDER BY query COLLATE "C"; query | application_name --------------------------------------------------------------------------------+----------------------------- SELECT $1 AS num | pg_regress/application_name SELECT pg_stat_monitor_reset(); | pg_regress/application_name SELECT query,application_name FROM pg_stat_monitor ORDER BY query COLLATE "C"; | pg_regress/application_name (3 rows) SELECT pg_stat_monitor_reset(); pg_stat_monitor_reset ----------------------- (1 row) DROP EXTENSION pg_stat_monitor;