pgFouine: PostgreSQL log analysis report

Normalized reports are marked with a "(N)".

Overall statistics ^

Queries by type ^

Type Count Percentage
SELECT 210,483 81.8
UPDATE 46,774 18.2

Slowest queries ^

Rank Duration (s) Query
1 4,777.68
UPDATE accounts SET filler=lower('teSt fiLlEr') WHERE aid < 1000;
2 3,949.61
UPDATE accounts SET filler=lower('teSt fiLlEr') WHERE aid < 1000;
3 3,763.44
UPDATE accounts SET filler=lower('teSt fiLlEr') WHERE aid < 1000;
4 3,696.27
UPDATE accounts SET filler=lower('teSt fiLlEr') WHERE aid < 1000;
5 3,687.32
UPDATE accounts SET filler=lower('teSt fiLlEr') WHERE aid < 1000;
6 3,672.68
UPDATE accounts SET filler=lower('teSt fiLlEr') WHERE aid < 1000;
7 3,539.89
UPDATE accounts SET filler=lower('teSt fiLlEr') WHERE aid < 1000;
8 3,418.57
UPDATE accounts SET filler=lower('teSt fiLlEr') WHERE aid < 1000;
9 3,371.81
UPDATE accounts SET filler=lower('teSt fiLlEr') WHERE aid < 1000;
10 3,207.66
UPDATE accounts SET filler=lower('teSt fiLlEr') WHERE aid < 1000;
11 3,205.61
UPDATE accounts SET filler=lower('teSt fiLlEr') WHERE aid < 1000;
12 3,186.41
UPDATE accounts SET filler=lower('teSt fiLlEr') WHERE aid < 1000;
13 3,164.53
UPDATE accounts SET filler=lower('teSt fiLlEr') WHERE aid < 1000;
14 3,148.11
UPDATE accounts SET filler=lower('teSt fiLlEr') WHERE aid < 1000;
15 3,100.01
UPDATE accounts SET filler=lower('teSt fiLlEr') WHERE aid < 1000;
16 3,050.80
UPDATE accounts SET filler=lower('teSt fiLlEr') WHERE aid < 1000;
17 3,027.34
UPDATE accounts SET filler=lower('teSt fiLlEr') WHERE aid < 1000;
18 3,025.56
UPDATE accounts SET filler=lower('teSt fiLlEr') WHERE aid < 1000;
19 2,977.51
UPDATE accounts SET filler=lower('teSt fiLlEr') WHERE aid < 1000;
20 2,920.77
UPDATE accounts SET filler=lower('teSt fiLlEr') WHERE aid < 1000;

Queries that took up the most time (N) ^

Rank Total duration Times executed Av. duration (s) Query
1 1933h26m41s 297.62
UPDATE accounts SET filler=lower('') WHERE aid < 0;
2 17h14m20s 2.65
UPDATE branches SET filler=upper('');
3 17m13s 0.04
SELECT history.* FROM accounts, history WHERE accounts.aid=0 AND accounts.aid=history.aid;
4 15m4s 0.04
SELECT accounts.* FROM accounts,history WHERE history.aid=0 AND accounts.aid=history.aid;
5 13m56s 0.04
SELECT history.* FROM accounts, branches, tellers, history WHERE accounts.aid=0 AND branches.bid=accounts.aid AND tellers.bid=accounts.aid AND history.aid=accounts.aid AND history.bid=branches.bid AND history.tid=tellers.tid;
6 5m32s 0.01
SELECT * FROM accounts WHERE aid=0;
7 1m38s 0.00
SELECT * FROM branches WHERE bid=0;
8 1m6s 0.00
SELECT * FROM tellers WHERE tid=0;
9 0.1s 0.00
SET search_path = public;

Most frequent queries (N) ^

Rank Times executed Total duration Av. duration (s) Query
1 1m6s 0.00
SELECT * FROM tellers WHERE tid=0;
2 5m32s 0.01
SELECT * FROM accounts WHERE aid=0;
3 1933h26m41s 297.62
UPDATE accounts SET filler=lower('') WHERE aid < 0;
4 17h14m20s 2.65
UPDATE branches SET filler=upper('');
5 17m13s 0.04
SELECT history.* FROM accounts, history WHERE accounts.aid=0 AND accounts.aid=history.aid;
6 15m4s 0.04
SELECT accounts.* FROM accounts,history WHERE history.aid=0 AND accounts.aid=history.aid;
7 13m56s 0.04
SELECT history.* FROM accounts, branches, tellers, history WHERE accounts.aid=0 AND branches.bid=accounts.aid AND tellers.bid=accounts.aid AND history.aid=accounts.aid AND history.bid=branches.bid AND history.tid=tellers.tid;
8 1m38s 0.00
SELECT * FROM branches WHERE bid=0;
9 0.1s 0.00
SET search_path = public;

Slowest queries (N) ^

Rank Av. duration (s) Times executed Total duration Query
1 297.62 1933h26m41s
UPDATE accounts SET filler=lower('') WHERE aid < 0;
2 2.65 17h14m20s
UPDATE branches SET filler=upper('');
3 0.04 17m13s
SELECT history.* FROM accounts, history WHERE accounts.aid=0 AND accounts.aid=history.aid;
4 0.04 15m4s
SELECT accounts.* FROM accounts,history WHERE history.aid=0 AND accounts.aid=history.aid;
5 0.04 13m56s
SELECT history.* FROM accounts, branches, tellers, history WHERE accounts.aid=0 AND branches.bid=accounts.aid AND tellers.bid=accounts.aid AND history.aid=accounts.aid AND history.bid=branches.bid AND history.tid=tellers.tid;
6 0.01 5m32s
SELECT * FROM accounts WHERE aid=0;
7 0.00 1m38s
SELECT * FROM branches WHERE bid=0;
8 0.00 0.1s
SET search_path = public;
9 0.00 1m6s
SELECT * FROM tellers WHERE tid=0;
Table of contents