Nikolay Samokhvalov

pg_buffercache report

2

proposal (quick and dirty draft): ```sql with a as ( SELECT reldatabase, c.relname, count(*) AS buffers FROM pg_buffercache b INNER JOIN pg_class c ON b.relfilenode = pg_relation_filenode(c.oid) GROUP BY 1,...

0: add info about pg_xlog/pg_wal

1

It's worth to see how many files / WAL segments are currently located in pg_xlog/pg_wal and what's the total size. ```sql select now()::timestamptz(0), count(1), pg_size_pretty(sum((pg_stat_file('pg_xlog/'||fname)).size)) as total_size from pg_ls_dir('pg_xlog') as...

see https://gist.github.com/NikolayS/21e508cf7cb33657f002077e793f3dd4

example: ``` select state, count(*) "Total count", count(*) filter (where now() - state_change '1 second') as "Old (1+ sec)" from pg_stat_activity group by cube(state); ``` \+ per host (`clent_addr`) \+...

Thanks for the great extension. Tried it on PG 14.1, and had the following issues: 1. TIMING and BUFFERS are not working – tried to set it everywhere, on both...

https://www.googleapis.com/language/translate/v2?key=XXXX&source=ru&target=en&q=5%3E2 responds with: ``` json { "data": { "translations": [ { "translatedText": "5> 2" } ] } } ``` – `>` char was converted to its HTML entities plus additional...