-
Global information
- Generated on Mon May 16 22:45:25 2022
- Log file: /data/pglog/huge_log_test/pgbouncer.log.1, ..., /data/pglog/huge_log_test/postgresql-Tue.log
- Parsed 247,924,278 log entries in 13m8s
- Log start from 2012-12-06 00:00:00 to 2012-12-12 00:00:00
-
Global Stats
- 3,606 Number of unique normalized queries
- 60,366,965 Number of queries
- 7d20h40m16s Total query duration
- 2012-12-06 00:00:00 First query
- 2012-12-12 00:00:00 Last query
- 787 queries/s at 2012-12-11 02:02:02 Query peak
- 7d20h40m16s Total query duration
- 1s974ms Prepare/parse total duration
- 1m38s Bind total duration
- 7d20h38m35s Execute total duration
- 3,965 Number of events
- 7 Number of unique normalized events
- 3,930 Max number of times the same event was reported
- 0 Number of cancellation
- 79 Total number of automatic vacuums
- 149 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 10,828,336 Total number of sessions
- 80 sessions at 2012-12-06 05:18:33 Session peak
- 1494d17h12m28s Total duration of sessions
- 11s926ms Average duration of sessions
- 5 Average queries per session
- 62ms Average queries duration per session
- 11s863ms Average idle time per session
- 10,828,340 Total number of connections
- 266 connections/s at 2012-12-07 02:02:02 Connection peak
- 6 Total number of databases
INSERT/UPDATE/DELETE Traffic
pgBadger