pgFouine: PostgreSQL log analysis report

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

Generated on 2007-03-30 20:58
Parsed /home/gsmet/work/pgfouine/logs_pgbench_20051211063633.log (608,204 lines) in 5m16s
Log from 2006-12-08 11:14:50 to 2006-12-11 06:36:31
Executed on edgewood

Overall statistics ^

Number of unique normalized queries: 9
Number of queries: 257,288
Total query duration: 1951h35m33s
First query: 2006-12-08 11:14:50
Last query: 2006-12-11 06:36:18
Query peak: 61 queries/s at 2006-12-08 11:14:50

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

1933h26m41s

23,387

Day	Time	Count	Av. Duration
Dec 8	11am	664	123.77
	12pm	708	148.94
	1pm	678	152.90
	2pm	673	158.20
	3pm	571	183.06
	4pm	588	178.70
	5pm	555	187.44
	6pm	534	199.17
	7pm	501	208.66
	8pm	516	197.44
	9pm	491	215.71
	10pm	464	226.38
	11pm	461	220.09
Dec 9	12am	434	247.36
	1am	417	249.90
	2am	407	263.47
	3am	387	262.69
	4am	412	249.56
	5am	402	266.61
	6am	392	265.30
	7am	361	287.02
	8am	370	282.57
	9am	357	294.51
	10am	358	296.80
	11am	349	293.52
	12pm	340	307.47
	1pm	326	314.28
	2pm	328	332.37
	3pm	329	306.43
	4pm	321	321.88
	5pm	318	336.96
	6pm	315	333.85
	7pm	316	332.54
	8pm	310	335.32
	9pm	303	343.95
	10pm	307	335.19
	11pm	303	349.38
Dec 10	12am	284	371.08
	1am	274	378.16
	2am	276	382.65
	3am	269	384.65
	4am	273	391.07
	5am	246	418.12
	6am	260	394.11
	7am	264	405.53
	8am	266	399.48
	9am	262	388.50
	10am	258	397.42
	11am	265	408.20
	12pm	251	417.00
	1pm	247	422.08
	2pm	250	401.49
	3pm	245	447.67
	4pm	240	422.58
	5pm	245	435.15
	6pm	241	429.47
	7pm	231	461.99
	8pm	227	467.49
	9pm	224	443.60
	10pm	232	447.71
	11pm	231	445.47
Dec 11	12am	231	469.16
	1am	229	419.74
	2am	223	445.24
	3am	226	439.66
	4am	223	436.96
	5am	218	352.47
	6am	110	272.39

297.62

UPDATE accounts SET filler=lower('') WHERE aid < 0;

17h14m20s

23,387

Day	Time	Count	Av. Duration
Dec 8	11am	635	1.10
	12pm	708	1.14
	1pm	678	1.24
	2pm	673	1.33
	3pm	571	1.42
	4pm	588	1.48
	5pm	555	1.56
	6pm	534	1.63
	7pm	501	1.71
	8pm	516	1.77
	9pm	491	1.84
	10pm	464	1.91
	11pm	461	1.98
Dec 9	12am	434	2.06
	1am	417	2.12
	2am	407	2.19
	3am	387	2.26
	4am	412	2.26
	5am	402	2.33
	6am	392	2.39
	7am	361	2.47
	8am	370	2.50
	9am	357	2.58
	10am	358	2.61
	11am	349	2.65
	12pm	340	2.71
	1pm	326	2.79
	2pm	328	2.80
	3pm	329	2.84
	4pm	321	2.90
	5pm	318	2.94
	6pm	315	2.98
	7pm	316	3.00
	8pm	310	3.06
	9pm	303	3.11
	10pm	307	3.12
	11pm	303	3.17
Dec 10	12am	284	3.26
	1am	274	3.33
	2am	276	3.36
	3am	269	3.41
	4am	273	3.43
	5am	246	3.56
	6am	260	3.53
	7am	264	3.54
	8am	266	3.56
	9am	262	3.59
	10am	258	3.65
	11am	265	3.66
	12pm	251	3.74
	1pm	247	3.78
	2pm	250	3.79
	3pm	245	3.84
	4pm	240	3.90
	5pm	245	3.89
	6pm	241	3.94
	7pm	231	4.03
	8pm	227	4.06
	9pm	224	4.12
	10pm	232	4.09
	11pm	232	4.11
Dec 11	12am	231	4.13
	1am	229	4.17
	2am	223	4.23
	3am	226	4.24
	4am	226	4.27
	5am	221	4.30
	6am	132	4.35

2.65

UPDATE branches SET filler=upper('');

17m13s

23,387

Day	Time	Count	Av. Duration
Dec 8	11am	635	0.05
	12pm	708	0.04
	1pm	678	0.04
	2pm	673	0.04
	3pm	570	0.04
	4pm	589	0.04
	5pm	555	0.04
	6pm	533	0.04
	7pm	502	0.04
	8pm	516	0.04
	9pm	491	0.04
	10pm	464	0.04
	11pm	461	0.04
Dec 9	12am	434	0.04
	1am	417	0.04
	2am	407	0.04
	3am	387	0.04
	4am	412	0.04
	5am	402	0.04
	6am	391	0.04
	7am	361	0.04
	8am	371	0.04
	9am	357	0.04
	10am	357	0.04
	11am	350	0.04
	12pm	339	0.04
	1pm	327	0.04
	2pm	328	0.04
	3pm	329	0.04
	4pm	321	0.04
	5pm	318	0.04
	6pm	314	0.04
	7pm	317	0.04
	8pm	309	0.04
	9pm	304	0.04
	10pm	307	0.04
	11pm	303	0.04
Dec 10	12am	284	0.04
	1am	274	0.04
	2am	276	0.04
	3am	268	0.04
	4am	273	0.04
	5am	246	0.04
	6am	260	0.04
	7am	264	0.04
	8am	266	0.04
	9am	263	0.04
	10am	258	0.04
	11am	265	0.04
	12pm	251	0.04
	1pm	247	0.04
	2pm	250	0.04
	3pm	245	0.04
	4pm	239	0.04
	5pm	246	0.04
	6pm	241	0.04
	7pm	230	0.04
	8pm	228	0.04
	9pm	223	0.04
	10pm	233	0.04
	11pm	232	0.04
Dec 11	12am	230	0.04
	1am	229	0.04
	2am	224	0.04
	3am	226	0.04
	4am	225	0.04
	5am	222	0.04
	6am	132	0.04

0.04

SELECT history.* FROM accounts, history WHERE accounts.aid=0 AND accounts.aid=history.aid;

15m4s

23,387

Day	Time	Count	Av. Duration
Dec 8	11am	635	0.04
	12pm	708	0.04
	1pm	678	0.04
	2pm	673	0.04
	3pm	570	0.04
	4pm	589	0.04
	5pm	555	0.04
	6pm	533	0.04
	7pm	502	0.04
	8pm	516	0.04
	9pm	491	0.04
	10pm	464	0.04
	11pm	461	0.04
Dec 9	12am	434	0.04
	1am	417	0.04
	2am	407	0.04
	3am	387	0.04
	4am	412	0.04
	5am	402	0.04
	6am	391	0.04
	7am	361	0.04
	8am	371	0.04
	9am	357	0.04
	10am	357	0.04
	11am	350	0.04
	12pm	339	0.04
	1pm	327	0.04
	2pm	328	0.04
	3pm	329	0.04
	4pm	321	0.04
	5pm	318	0.04
	6pm	314	0.04
	7pm	317	0.04
	8pm	309	0.04
	9pm	304	0.04
	10pm	307	0.04
	11pm	303	0.04
Dec 10	12am	284	0.04
	1am	274	0.04
	2am	276	0.04
	3am	268	0.04
	4am	273	0.04
	5am	246	0.04
	6am	260	0.04
	7am	264	0.04
	8am	266	0.04
	9am	263	0.04
	10am	258	0.04
	11am	265	0.04
	12pm	251	0.04
	1pm	247	0.04
	2pm	250	0.04
	3pm	245	0.04
	4pm	239	0.04
	5pm	246	0.04
	6pm	241	0.04
	7pm	230	0.04
	8pm	228	0.04
	9pm	223	0.04
	10pm	233	0.04
	11pm	232	0.04
Dec 11	12am	230	0.04
	1am	229	0.04
	2am	224	0.04
	3am	226	0.04
	4am	225	0.04
	5am	222	0.04
	6am	132	0.04

0.04

SELECT accounts.* FROM accounts,history WHERE history.aid=0 AND accounts.aid=history.aid;

13m56s

23,387

Day	Time	Count	Av. Duration
Dec 8	11am	635	0.04
	12pm	708	0.04
	1pm	678	0.04
	2pm	673	0.04
	3pm	570	0.04
	4pm	589	0.03
	5pm	555	0.04
	6pm	533	0.04
	7pm	502	0.03
	8pm	516	0.04
	9pm	491	0.04
	10pm	464	0.04
	11pm	461	0.04
Dec 9	12am	434	0.04
	1am	417	0.04
	2am	407	0.04
	3am	387	0.04
	4am	412	0.04
	5am	402	0.04
	6am	391	0.04
	7am	361	0.04
	8am	371	0.04
	9am	357	0.04
	10am	357	0.04
	11am	350	0.04
	12pm	339	0.04
	1pm	327	0.03
	2pm	328	0.03
	3pm	329	0.04
	4pm	321	0.04
	5pm	318	0.04
	6pm	314	0.04
	7pm	317	0.04
	8pm	309	0.04
	9pm	304	0.04
	10pm	307	0.04
	11pm	303	0.04
Dec 10	12am	284	0.04
	1am	274	0.04
	2am	276	0.04
	3am	268	0.04
	4am	273	0.04
	5am	246	0.04
	6am	260	0.04
	7am	264	0.04
	8am	266	0.04
	9am	263	0.04
	10am	258	0.04
	11am	265	0.04
	12pm	251	0.04
	1pm	247	0.04
	2pm	250	0.04
	3pm	245	0.04
	4pm	239	0.04
	5pm	246	0.04
	6pm	241	0.03
	7pm	230	0.04
	8pm	228	0.04
	9pm	223	0.04
	10pm	233	0.03
	11pm	232	0.04
Dec 11	12am	230	0.04
	1am	229	0.04
	2am	224	0.03
	3am	226	0.04
	4am	225	0.04
	5am	222	0.04
	6am	132	0.04

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;

5m32s

46,774

Day	Time	Count	Av. Duration
Dec 8	11am	1,270	0.03
	12pm	1,416	0.01
	1pm	1,356	0.01
	2pm	1,346	0.00
	3pm	1,141	0.00
	4pm	1,177	0.00
	5pm	1,110	0.00
	6pm	1,067	0.00
	7pm	1,003	0.00
	8pm	1,032	0.00
	9pm	982	0.00
	10pm	928	0.00
	11pm	922	0.00
Dec 9	12am	868	0.00
	1am	834	0.00
	2am	814	0.01
	3am	774	0.01
	4am	824	0.01
	5am	804	0.01
	6am	783	0.01
	7am	722	0.01
	8am	741	0.01
	9am	714	0.01
	10am	715	0.01
	11am	699	0.00
	12pm	679	0.01
	1pm	653	0.00
	2pm	656	0.01
	3pm	658	0.00
	4pm	642	0.01
	5pm	636	0.00
	6pm	629	0.00
	7pm	633	0.00
	8pm	619	0.01
	9pm	607	0.00
	10pm	614	0.01
	11pm	606	0.01
Dec 10	12am	568	0.01
	1am	548	0.01
	2am	552	0.01
	3am	537	0.01
	4am	546	0.01
	5am	492	0.01
	6am	520	0.01
	7am	528	0.01
	8am	532	0.01
	9am	525	0.01
	10am	516	0.01
	11am	530	0.01
	12pm	502	0.01
	1pm	494	0.01
	2pm	500	0.01
	3pm	490	0.01
	4pm	479	0.01
	5pm	491	0.01
	6pm	482	0.01
	7pm	461	0.01
	8pm	455	0.01
	9pm	447	0.01
	10pm	465	0.01
	11pm	464	0.01
Dec 11	12am	461	0.01
	1am	458	0.01
	2am	447	0.01
	3am	452	0.01
	4am	451	0.01
	5am	443	0.01
	6am	264	0.01

0.01

SELECT * FROM accounts WHERE aid=0;

1m38s

23,387

Day	Time	Count	Av. Duration
Dec 8	11am	635	0.00
	12pm	708	0.00
	1pm	678	0.00
	2pm	673	0.00
	3pm	571	0.01
	4pm	588	0.00
	5pm	555	0.01
	6pm	534	0.00
	7pm	501	0.01
	8pm	516	0.00
	9pm	491	0.01
	10pm	464	0.00
	11pm	461	0.01
Dec 9	12am	434	0.01
	1am	417	0.00
	2am	407	0.00
	3am	387	0.00
	4am	412	0.00
	5am	402	0.00
	6am	392	0.00
	7am	361	0.01
	8am	370	0.00
	9am	357	0.00
	10am	358	0.00
	11am	349	0.00
	12pm	340	0.00
	1pm	326	0.00
	2pm	328	0.01
	3pm	329	0.00
	4pm	321	0.00
	5pm	318	0.01
	6pm	315	0.01
	7pm	316	0.00
	8pm	310	0.01
	9pm	303	0.01
	10pm	307	0.00
	11pm	303	0.01
Dec 10	12am	284	0.00
	1am	274	0.00
	2am	276	0.01
	3am	269	0.01
	4am	273	0.00
	5am	246	0.01
	6am	260	0.01
	7am	264	0.00
	8am	266	0.00
	9am	262	0.00
	10am	258	0.00
	11am	265	0.00
	12pm	251	0.00
	1pm	247	0.01
	2pm	250	0.00
	3pm	245	0.01
	4pm	240	0.00
	5pm	245	0.00
	6pm	241	0.00
	7pm	231	0.01
	8pm	227	0.01
	9pm	224	0.01
	10pm	232	0.00
	11pm	232	0.00
Dec 11	12am	231	0.00
	1am	229	0.00
	2am	223	0.00
	3am	226	0.01
	4am	226	0.00
	5am	221	0.01
	6am	132	0.01

0.00

SELECT * FROM branches WHERE bid=0;

1m6s

70,161

Day	Time	Count
Dec 8	11am	1,905
	12pm	2,124
	1pm	2,034
	2pm	2,019
	3pm	1,711
	4pm	1,766
	5pm	1,665
	6pm	1,600
	7pm	1,505
	8pm	1,548
	9pm	1,473
	10pm	1,392
	11pm	1,383
Dec 9	12am	1,302
	1am	1,251
	2am	1,221
	3am	1,161
	4am	1,236
	5am	1,206
	6am	1,174
	7am	1,083
	8am	1,112
	9am	1,071
	10am	1,072
	11am	1,049
	12pm	1,018
	1pm	980
	2pm	984
	3pm	987
	4pm	963
	5pm	954
	6pm	943
	7pm	950
	8pm	928
	9pm	911
	10pm	921
	11pm	909
Dec 10	12am	852
	1am	822
	2am	828
	3am	805
	4am	819
	5am	738
	6am	780
	7am	792
	8am	798
	9am	788
	10am	774
	11am	795
	12pm	753
	1pm	741
	2pm	750
	3pm	735
	4pm	718
	5pm	737
	6pm	723
	7pm	691
	8pm	683
	9pm	670
	10pm	698
	11pm	696
Dec 11	12am	691
	1am	687
	2am	671
	3am	678
	4am	676
	5am	665
	6am	396

0.00

SELECT * FROM tellers WHERE tid=0;

0.1s

0.00

SET search_path = public;

Most frequent queries (N) ^

Rank

Times executed

Total duration

Av. duration (s)

Query

70,161

Day	Time	Count
Dec 8	11am	1,905
	12pm	2,124
	1pm	2,034
	2pm	2,019
	3pm	1,711
	4pm	1,766
	5pm	1,665
	6pm	1,600
	7pm	1,505
	8pm	1,548
	9pm	1,473
	10pm	1,392
	11pm	1,383
Dec 9	12am	1,302
	1am	1,251
	2am	1,221
	3am	1,161
	4am	1,236
	5am	1,206
	6am	1,174
	7am	1,083
	8am	1,112
	9am	1,071
	10am	1,072
	11am	1,049
	12pm	1,018
	1pm	980
	2pm	984
	3pm	987
	4pm	963
	5pm	954
	6pm	943
	7pm	950
	8pm	928
	9pm	911
	10pm	921
	11pm	909
Dec 10	12am	852
	1am	822
	2am	828
	3am	805
	4am	819
	5am	738
	6am	780
	7am	792
	8am	798
	9am	788
	10am	774
	11am	795
	12pm	753
	1pm	741
	2pm	750
	3pm	735
	4pm	718
	5pm	737
	6pm	723
	7pm	691
	8pm	683
	9pm	670
	10pm	698
	11pm	696
Dec 11	12am	691
	1am	687
	2am	671
	3am	678
	4am	676
	5am	665
	6am	396

1m6s

0.00

SELECT * FROM tellers WHERE tid=0;

46,774

Day	Time	Count	Av. Duration
Dec 8	11am	1,270	0.03
	12pm	1,416	0.01
	1pm	1,356	0.01
	2pm	1,346	0.00
	3pm	1,141	0.00
	4pm	1,177	0.00
	5pm	1,110	0.00
	6pm	1,067	0.00
	7pm	1,003	0.00
	8pm	1,032	0.00
	9pm	982	0.00
	10pm	928	0.00
	11pm	922	0.00
Dec 9	12am	868	0.00
	1am	834	0.00
	2am	814	0.01
	3am	774	0.01
	4am	824	0.01
	5am	804	0.01
	6am	783	0.01
	7am	722	0.01
	8am	741	0.01
	9am	714	0.01
	10am	715	0.01
	11am	699	0.00
	12pm	679	0.01
	1pm	653	0.00
	2pm	656	0.01
	3pm	658	0.00
	4pm	642	0.01
	5pm	636	0.00
	6pm	629	0.00
	7pm	633	0.00
	8pm	619	0.01
	9pm	607	0.00
	10pm	614	0.01
	11pm	606	0.01
Dec 10	12am	568	0.01
	1am	548	0.01
	2am	552	0.01
	3am	537	0.01
	4am	546	0.01
	5am	492	0.01
	6am	520	0.01
	7am	528	0.01
	8am	532	0.01
	9am	525	0.01
	10am	516	0.01
	11am	530	0.01
	12pm	502	0.01
	1pm	494	0.01
	2pm	500	0.01
	3pm	490	0.01
	4pm	479	0.01
	5pm	491	0.01
	6pm	482	0.01
	7pm	461	0.01
	8pm	455	0.01
	9pm	447	0.01
	10pm	465	0.01
	11pm	464	0.01
Dec 11	12am	461	0.01
	1am	458	0.01
	2am	447	0.01
	3am	452	0.01
	4am	451	0.01
	5am	443	0.01
	6am	264	0.01

5m32s

0.01

SELECT * FROM accounts WHERE aid=0;

23,387

Day	Time	Count	Av. Duration
Dec 8	11am	664	123.77
	12pm	708	148.94
	1pm	678	152.90
	2pm	673	158.20
	3pm	571	183.06
	4pm	588	178.70
	5pm	555	187.44
	6pm	534	199.17
	7pm	501	208.66
	8pm	516	197.44
	9pm	491	215.71
	10pm	464	226.38
	11pm	461	220.09
Dec 9	12am	434	247.36
	1am	417	249.90
	2am	407	263.47
	3am	387	262.69
	4am	412	249.56
	5am	402	266.61
	6am	392	265.30
	7am	361	287.02
	8am	370	282.57
	9am	357	294.51
	10am	358	296.80
	11am	349	293.52
	12pm	340	307.47
	1pm	326	314.28
	2pm	328	332.37
	3pm	329	306.43
	4pm	321	321.88
	5pm	318	336.96
	6pm	315	333.85
	7pm	316	332.54
	8pm	310	335.32
	9pm	303	343.95
	10pm	307	335.19
	11pm	303	349.38
Dec 10	12am	284	371.08
	1am	274	378.16
	2am	276	382.65
	3am	269	384.65
	4am	273	391.07
	5am	246	418.12
	6am	260	394.11
	7am	264	405.53
	8am	266	399.48
	9am	262	388.50
	10am	258	397.42
	11am	265	408.20
	12pm	251	417.00
	1pm	247	422.08
	2pm	250	401.49
	3pm	245	447.67
	4pm	240	422.58
	5pm	245	435.15
	6pm	241	429.47
	7pm	231	461.99
	8pm	227	467.49
	9pm	224	443.60
	10pm	232	447.71
	11pm	231	445.47
Dec 11	12am	231	469.16
	1am	229	419.74
	2am	223	445.24
	3am	226	439.66
	4am	223	436.96
	5am	218	352.47
	6am	110	272.39

1933h26m41s

297.62

UPDATE accounts SET filler=lower('') WHERE aid < 0;

23,387

Day	Time	Count	Av. Duration
Dec 8	11am	635	1.10
	12pm	708	1.14
	1pm	678	1.24
	2pm	673	1.33
	3pm	571	1.42
	4pm	588	1.48
	5pm	555	1.56
	6pm	534	1.63
	7pm	501	1.71
	8pm	516	1.77
	9pm	491	1.84
	10pm	464	1.91
	11pm	461	1.98
Dec 9	12am	434	2.06
	1am	417	2.12
	2am	407	2.19
	3am	387	2.26
	4am	412	2.26
	5am	402	2.33
	6am	392	2.39
	7am	361	2.47
	8am	370	2.50
	9am	357	2.58
	10am	358	2.61
	11am	349	2.65
	12pm	340	2.71
	1pm	326	2.79
	2pm	328	2.80
	3pm	329	2.84
	4pm	321	2.90
	5pm	318	2.94
	6pm	315	2.98
	7pm	316	3.00
	8pm	310	3.06
	9pm	303	3.11
	10pm	307	3.12
	11pm	303	3.17
Dec 10	12am	284	3.26
	1am	274	3.33
	2am	276	3.36
	3am	269	3.41
	4am	273	3.43
	5am	246	3.56
	6am	260	3.53
	7am	264	3.54
	8am	266	3.56
	9am	262	3.59
	10am	258	3.65
	11am	265	3.66
	12pm	251	3.74
	1pm	247	3.78
	2pm	250	3.79
	3pm	245	3.84
	4pm	240	3.90
	5pm	245	3.89
	6pm	241	3.94
	7pm	231	4.03
	8pm	227	4.06
	9pm	224	4.12
	10pm	232	4.09
	11pm	232	4.11
Dec 11	12am	231	4.13
	1am	229	4.17
	2am	223	4.23
	3am	226	4.24
	4am	226	4.27
	5am	221	4.30
	6am	132	4.35

17h14m20s

2.65

UPDATE branches SET filler=upper('');

23,387

Day	Time	Count	Av. Duration
Dec 8	11am	635	0.05
	12pm	708	0.04
	1pm	678	0.04
	2pm	673	0.04
	3pm	570	0.04
	4pm	589	0.04
	5pm	555	0.04
	6pm	533	0.04
	7pm	502	0.04
	8pm	516	0.04
	9pm	491	0.04
	10pm	464	0.04
	11pm	461	0.04
Dec 9	12am	434	0.04
	1am	417	0.04
	2am	407	0.04
	3am	387	0.04
	4am	412	0.04
	5am	402	0.04
	6am	391	0.04
	7am	361	0.04
	8am	371	0.04
	9am	357	0.04
	10am	357	0.04
	11am	350	0.04
	12pm	339	0.04
	1pm	327	0.04
	2pm	328	0.04
	3pm	329	0.04
	4pm	321	0.04
	5pm	318	0.04
	6pm	314	0.04
	7pm	317	0.04
	8pm	309	0.04
	9pm	304	0.04
	10pm	307	0.04
	11pm	303	0.04
Dec 10	12am	284	0.04
	1am	274	0.04
	2am	276	0.04
	3am	268	0.04
	4am	273	0.04
	5am	246	0.04
	6am	260	0.04
	7am	264	0.04
	8am	266	0.04
	9am	263	0.04
	10am	258	0.04
	11am	265	0.04
	12pm	251	0.04
	1pm	247	0.04
	2pm	250	0.04
	3pm	245	0.04
	4pm	239	0.04
	5pm	246	0.04
	6pm	241	0.04
	7pm	230	0.04
	8pm	228	0.04
	9pm	223	0.04
	10pm	233	0.04
	11pm	232	0.04
Dec 11	12am	230	0.04
	1am	229	0.04
	2am	224	0.04
	3am	226	0.04
	4am	225	0.04
	5am	222	0.04
	6am	132	0.04

17m13s

0.04

SELECT history.* FROM accounts, history WHERE accounts.aid=0 AND accounts.aid=history.aid;

23,387

Day	Time	Count	Av. Duration
Dec 8	11am	635	0.04
	12pm	708	0.04
	1pm	678	0.04
	2pm	673	0.04
	3pm	570	0.04
	4pm	589	0.04
	5pm	555	0.04
	6pm	533	0.04
	7pm	502	0.04
	8pm	516	0.04
	9pm	491	0.04
	10pm	464	0.04
	11pm	461	0.04
Dec 9	12am	434	0.04
	1am	417	0.04
	2am	407	0.04
	3am	387	0.04
	4am	412	0.04
	5am	402	0.04
	6am	391	0.04
	7am	361	0.04
	8am	371	0.04
	9am	357	0.04
	10am	357	0.04
	11am	350	0.04
	12pm	339	0.04
	1pm	327	0.04
	2pm	328	0.04
	3pm	329	0.04
	4pm	321	0.04
	5pm	318	0.04
	6pm	314	0.04
	7pm	317	0.04
	8pm	309	0.04
	9pm	304	0.04
	10pm	307	0.04
	11pm	303	0.04
Dec 10	12am	284	0.04
	1am	274	0.04
	2am	276	0.04
	3am	268	0.04
	4am	273	0.04
	5am	246	0.04
	6am	260	0.04
	7am	264	0.04
	8am	266	0.04
	9am	263	0.04
	10am	258	0.04
	11am	265	0.04
	12pm	251	0.04
	1pm	247	0.04
	2pm	250	0.04
	3pm	245	0.04
	4pm	239	0.04
	5pm	246	0.04
	6pm	241	0.04
	7pm	230	0.04
	8pm	228	0.04
	9pm	223	0.04
	10pm	233	0.04
	11pm	232	0.04
Dec 11	12am	230	0.04
	1am	229	0.04
	2am	224	0.04
	3am	226	0.04
	4am	225	0.04
	5am	222	0.04
	6am	132	0.04

15m4s

0.04

SELECT accounts.* FROM accounts,history WHERE history.aid=0 AND accounts.aid=history.aid;