pgFouine: PostgreSQL log analysis report
Normalized reports are marked with a "(N)".
- Generated on 2006-03-26 01:03
- Parsed /home/gsmet/work/pgfouine/pgsql-20060126-0400 (14,723,233 lines) in 1h34m57s
- Log from 2006-01-25 04:03:28 to 2006-01-26 04:03:27
- Executed on edgewood
Overall statistics ^
- Number of unique normalized queries: 1,239
- Number of queries: 12,358,514 (identified: 138,788)
- Total query duration: 126h22m4s (identified: 81h35m34s)
- First query: 2006-01-25 04:03:28
- Last query: 2006-01-26 04:03:27
- Query peak: 1,123 queries/s at 2006-01-26 03:05:04
- Number of errors: 760
- Number of unique normalized errors: 126
Hourly statistics ^
| Day | Time | Queries | SELECT queries | Write queries | |||||
|---|---|---|---|---|---|---|---|---|---|
| Count | Av. duration | Count | Av. duration | INSERT | UPDATE | DELETE | Av. duration | ||
| Jan 25 | 4am | 173960 | 0.01 | 869 | 0.94 | 0 | 0 | 0 | 0.00 |
| 5am | 170838 | 0.01 | 891 | 0.87 | 0 | 0 | 0 | 0.00 | |
| 6am | 203281 | 0.01 | 889 | 0.97 | 0 | 0 | 0 | 0.00 | |
| 7am | 273996 | 0.01 | 1233 | 0.91 | 0 | 0 | 0 | 0.00 | |
| 8am | 417109 | 0.02 | 2112 | 1.10 | 0 | 0 | 1 | 1.35 | |
| 9am | 554586 | 0.03 | 5965 | 1.82 | 0 | 4 | 0 | 0.66 | |
| 10am | 645654 | 0.05 | 10764 | 2.07 | 2 | 8 | 1 | 0.77 | |
| 11am | 668083 | 0.16 | 26830 | 3.30 | 25 | 64 | 1 | 0.83 | |
| 12pm | 620175 | 0.03 | 6374 | 1.66 | 2 | 4 | 4 | 1.46 | |
| 1pm | 614577 | 0.08 | 14043 | 2.81 | 7 | 21 | 3 | 0.93 | |
| 2pm | 629701 | 0.04 | 8182 | 1.96 | 2 | 3 | 0 | 0.69 | |
| 3pm | 613642 | 0.04 | 8412 | 2.12 | 7 | 7 | 0 | 0.94 | |
| 4pm | 639978 | 0.04 | 7963 | 1.82 | 2 | 3 | 0 | 0.74 | |
| 5pm | 657274 | 0.03 | 7780 | 1.56 | 0 | 2 | 1 | 0.81 | |
| 6pm | 675671 | 0.06 | 12477 | 2.19 | 5 | 10 | 1 | 0.73 | |
| 7pm | 566039 | 0.02 | 4258 | 1.39 | 0 | 0 | 0 | 0.00 | |
| 8pm | 510561 | 0.02 | 2481 | 1.34 | 2 | 1 | 4 | 9.93 | |
| 9pm | 501863 | 0.03 | 3885 | 1.41 | 170 | 22 | 3 | 4.89 | |
| 10pm | 439288 | 0.02 | 2297 | 1.09 | 392 | 0 | 0 | 0.70 | |
| 11pm | 331628 | 0.02 | 1237 | 1.16 | 696 | 0 | 0 | 0.65 | |
| Jan 26 | 12am | 424657 | 0.02 | 885 | 0.97 | 5115 | 30 | 0 | 0.63 |
| 1am | 1159789 | 0.00 | 681 | 1.13 | 271 | 13 | 0 | 1.70 | |
| 2am | 734956 | 0.00 | 722 | 1.14 | 0 | 0 | 0 | 0.00 | |
| 3am | 124986 | 0.02 | 539 | 2.03 | 0 | 1 | 0 | 2.10 | |
| 4am | 6222 | 0.01 | 19 | 0.68 | 0 | 0 | 0 | 0.00 | |
