From: | Sreekanth Palluru <sree4pg(at)gmail(dot)com> |
---|---|
To: | PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org> |
Subject: | Moving from pgFouine to pgBadger Issue with Total query duration metric |
Date: | 2018-01-12 05:02:06 |
Message-ID: | CAP+fnphxBjEJe+4x0cYhmCXH6ZR5ZY8aTVq3V6zWx+6OrZZu2g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi ,
I am moving from pgFouine to pgBadger. When I compare the reports I see
that there is major difference in time reported by metric *Total query
duration* for given same postgres server log file.( excuse me for not
sharing the postgres server logfile )
pgfouine reports around 2hrs where as pgBadger reports around 4hrs.
I am using below command options to execute the report. I am mainly
comparing pgBadger report with queries.html report
Appreciate your help on this ? wanted to know why there so much difference
in time ?
*pgFouine*
/home/postgres/fouine/pgfouine-1.2/pgfouine.php -logtype stderr -file
$filename -top 30 \
-report
/tmp/queries.html=overall,bytype,slowest,n-mosttime,n-mostfrequent,n-slowestaverage
\
-report /tmp/hourly.html=overall,hourly \
-report /tmp/errors.html=overall,n-mostfrequenterrors \
-database $1
*pgBadger*
perl pgbadger -t 30 --disable-session --disable-connection --disable-lock
--disable-temporary --disable-checkpoint --disable-autovacuum -o
pgbadger_out_3.html -d <DBNAME>
/home/postgres/postgresql-2018-01-11_000000.log
pgFouine => Overall statistics
· Overall statistics ^
- Number of unique normalized queries: 208
- Number of queries: 2,111
- Total query duration: 2h36m45s
- First query: 2018-01-11 00:01:06
- Last query: 2018-01-11 23:20:07
- Query peak: 6 queries/s at 2018-01-11 14:26:18
- Number of errors: 70,043
- Number of unique normalized errors: 19
pgBadger => Global Stats
Global Stats
- Queries
- Events
- Vacuums
- Temporary files
- Sessions
- Connections
- *207* Number of unique normalized queries
- *2,113* Number of queries
- *4h41m48s* Total query duration
- *2018-01-11 00:01:06* First query
- *2018-01-11 23:20:07* Last query
- *6 queries/s at 2018-01-11 17:41:30* Query peak
--
Regards
Sreekanth
From | Date | Subject | |
---|---|---|---|
Next Message | Sachin Kotwal | 2018-01-12 07:25:18 | Update blocking another update |
Previous Message | armand pirvu | 2018-01-12 01:52:03 | Re: characters converted to ??? in postgres |