/
githubmirror
/
postgres
Обзор
Документация
Войти
/
githubmirror
/
postgres
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
contrib/pg_stat_statements/sql/wal.sql
20 строк
617 B
Alexander Korotkov
Add NOT NULL checking of pg_stat_statements_reset() in tests
27 ноя 2023, 03:52
27 ноя 2023, 03:52
6ab1dbd
Код
Авторство
О чём код?
-- -- Validate WAL generation metrics -- SET pg_stat_statements.track_utility = FALSE; CREATE TABLE pgss_wal_tab (a int, b char(20)); INSERT INTO pgss_wal_tab VALUES(generate_series(1, 10), 'aaa'); UPDATE pgss_wal_tab SET b = 'bbb' WHERE a > 7; DELETE FROM pgss_wal_tab WHERE a > 9; DROP TABLE pgss_wal_tab; -- Check WAL is generated for the above statements SELECT query, calls, rows, wal_bytes > 0 as wal_bytes_generated, wal_records > 0 as wal_records_generated, wal_records >= rows as wal_records_ge_rows FROM pg_stat_statements ORDER BY query COLLATE "C"; SELECT pg_stat_statements_reset() IS NOT NULL AS t;