mirror of
https://github.com/percona/pg_stat_monitor.git
synced 2026-02-04 14:06:20 +00:00
db5a6aa30e
The query status monitoring code was used to track the current query state, for example, parsing, executing and finishing. After careful review, we have figured out that it does not make sense while a lot of time same query is running. Therefore it is also consuming resources. This commit will remove that feature. The upgrade SQL from 1.0 - 2.0 is also updated.
47 lines
1.7 KiB
Plaintext
47 lines
1.7 KiB
Plaintext
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
|
|
----------------------------------+--------+---------+-----------------------------------
|
|
ELECET * FROM unknown; | 20 | 42601 | syntax error at or near "ELECET"
|
|
SELECT * FROM unknown; | 20 | 42P01 | relation "unknown" does not exist
|
|
SELECT 1/0; | 20 | 22012 | division by zero
|
|
SELECT pg_stat_monitor_reset() | 0 | |
|
|
do $$ +| 0 | |
|
|
BEGIN +| | |
|
|
RAISE WARNING 'warning message';+| | |
|
|
END $$ | | |
|
|
do $$ +| 19 | 01000 | warning message
|
|
BEGIN +| | |
|
|
RAISE WARNING 'warning message';+| | |
|
|
END $$; | | |
|
|
(6 rows)
|
|
|
|
SELECT pg_stat_monitor_reset();
|
|
pg_stat_monitor_reset
|
|
-----------------------
|
|
|
|
(1 row)
|
|
|
|
DROP EXTENSION pg_stat_monitor;
|