CREATE EXTENSION pg_stat_monitor; SELECT pg_stat_monitor_reset(); pg_stat_monitor_reset ----------------------- (1 row) SELECT 1 / 0; -- divide by zero ERROR: division by zero SELECT * FROM unknown; -- unknown table ERROR: relation "unknown" does not exist LINE 1: SELECT * FROM unknown; ^ ELECET * FROM unknown; -- syntax error ERROR: syntax error at or near "ELECET" LINE 1: ELECET * FROM unknown; ^ DO $$ BEGIN RAISE WARNING 'warning message'; END $$; WARNING: warning message SELECT query, elevel, sqlcode, message FROM pg_stat_monitor ORDER BY query COLLATE "C", elevel; query | elevel | sqlcode | message --------------------------------------+--------+---------+----------------------------------- DO $$ +| 0 | | BEGIN +| | | RAISE WARNING 'warning message';+| | | END +| | | $$ | | | DO $$ +| 19 | 01000 | warning message BEGIN +| | | RAISE WARNING 'warning message';+| | | END +| | | $$; | | | ELECET * FROM unknown; | 21 | 42601 | syntax error at or near "ELECET" SELECT * FROM unknown; | 21 | 42P01 | relation "unknown" does not exist SELECT 1 / 0; | 21 | 22012 | division by zero SELECT pg_stat_monitor_reset() | 0 | | (6 rows) SELECT pg_stat_monitor_reset(); pg_stat_monitor_reset ----------------------- (1 row) DROP EXTENSION pg_stat_monitor;