pg-logstats 0.1.0

PostgreSQL log investigation CLI for query-family findings and follow-up SQL
Documentation 
1
2
3
4
5
6

2024-01-15 10:00:00.000 UTC [3001] app@appdb api: LOG:  statement: SELECT * FROM users WHERE id = 3;
2024-01-15 10:00:00.100 UTC [3001] app@appdb api: LOG:  duration: 100.000 ms
2024-01-15 10:00:01.000 UTC [3002] app@appdb api: LOG:  statement: SELECT * FROM users WHERE id = 4;
2024-01-15 10:00:01.150 UTC [3002] app@appdb api: LOG:  duration: 150.000 ms
2024-01-15 10:00:02.000 UTC [3003] app@appdb api: LOG:  statement: SELECT * FROM orders WHERE id = 1;
2024-01-15 10:00:02.200 UTC [3003] app@appdb api: LOG:  duration: 200.000 ms