pgBadger :: PostgreSQL Log Analyzer

Global Stats

3,751 Number of unique normalized queries
60,367,937 Number of queries
7d21h24m32s 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

3,950 Number of events
6 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

235 Number temporary file
24.59 MiB Max size of temporary file
12.06 MiB Average size of temporary file

10,828,337 Total number of sessions
334 sessions at 2012-12-07 00:00:00 Session peak
1494d17h13m24s Total duration of sessions
11s926ms Average duration of sessions
5 Average queries per session
62ms Average queries duration per session

10,828,340 Total number of connections
266 connections/s at 2012-12-07 02:02:02 Connection peak
9 Total number of databases

SQL Traffic

Key values

787 queries/s Query Peak
2012-12-11 02:02:02 Date

SELECT Traffic

Key values

108 queries/s Query Peak
2012-12-11 10:49:56 Date

INSERT/UPDATE/DELETE Traffic

Key values

72 queries/s Query Peak
2012-12-06 09:06:28 Date

Queries duration

Key values

7d21h24m32s Total query duration

Prepared queries ratio

Key values

130.67 Ratio of bind vs prepare
0.87 % Ratio between prepared and "usual" statements

General Activity

Day	Hour	Count	Min duration	Max duration	Avg duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 06	00	871,022	0ms	44s462ms	12ms	3m11s	3m14s	4m55s
	01	859,523	0ms	2s111ms	12ms	3m14s	3m17s	4m3s
	02	916,750	0ms	1s797ms	12ms	3m19s	3m27s	3m34s
	03	938,542	0ms	2s8ms	12ms	3m24s	3m27s	3m33s
	04	317,511	0ms	5s121ms	11ms	1m58s	3m	3m55s
	05	232,849	0ms	4m28s	54ms	6m6s	15m3s	1h17m5s
	06	290,384	0ms	2m3s	20ms	2m53s	5m26s	12m6s
	07	493,028	0ms	2m2s	14ms	3m12s	3m57s	5m10s
	08	640,573	0ms	1m15s	13ms	2m55s	3m13s	3m45s
	09	720,251	0ms	1m45s	14ms	3m52s	5m49s	11m6s
	10	814,319	0ms	1m18s	12ms	3m49s	3m57s	4m56s
	11	845,933	0ms	1m2s	12ms	3m14s	3m37s	4m7s
	12	849,782	0ms	1m10s	12ms	3m18s	3m43s	4m23s
	13	863,172	0ms	2s109ms	12ms	3m20s	3m30s	3m38s
	14	852,233	0ms	4s467ms	14ms	5m28s	6m53s	12m56s
	15	894,969	0ms	1s758ms	11ms	3m32s	3m38s	3m44s
	16	932,263	0ms	1m4s	11ms	3m40s	3m47s	4m31s
	17	918,316	0ms	2s620ms	11ms	3m31s	3m39s	3m55s
	18	922,675	0ms	1s772ms	13ms	4m35s	5m10s	5m45s
	19	911,582	0ms	2s213ms	12ms	3m26s	3m30s	3m40s
	20	921,774	0ms	20s749ms	12ms	3m25s	3m33s	7m15s
	21	922,400	0ms	11s807ms	11ms	3m22s	3m32s	5m28s
	22	914,023	0ms	1s797ms	12ms	3m49s	4m5s	4m56s
	23	943,658	0ms	1m8s	13ms	4m28s	4m41s	5m3s
Dec 07	00	922,241	0ms	41s106ms	12ms	3m35s	4m4s	4m20s
	01	905,559	0ms	1s757ms	12ms	3m16s	3m19s	3m30s
	02	942,735	0ms	56s896ms	13ms	3m43s	4m5s	24m6s
	03	988,647	0ms	1s760ms	13ms	4m43s	5m8s	5m15s
	04	378,358	0ms	3s355ms	11ms	2m7s	3m1s	3m25s
	05	286,448	0ms	3m46s	29ms	3m52s	8m42s	31m10s
	06	335,553	0ms	4m6s	26ms	6m20s	12m11s	22m3s
	07	529,065	0ms	2m38s	19ms	5m9s	5m47s	15m37s
	08	637,736	0ms	2m11s	14ms	3m45s	5m53s	7m31s
	09	768,182	0ms	1m16s	12ms	3m	3m45s	5m54s
	10	849,489	0ms	1m27s	14ms	3m59s	4m17s	6m23s
	11	874,880	0ms	4s679ms	12ms	3m7s	3m11s	3m27s
	12	881,050	0ms	1m11s	12ms	3m17s	4m4s	5m6s
	13	884,438	0ms	4s669ms	12ms	3m11s	3m40s	3m51s
	14	322,709	0ms	4s719ms	12ms	3m13s	3m15s	3m18s
	15	81,524	0ms	4s782ms	12ms	45s668ms	48s243ms	1m6s
	16	108,503	0ms	4s680ms	12ms	1m	1m1s	1m16s
	17	124,684	0ms	4s715ms	10ms	55s580ms	1m	1m2s
	18	120,555	0ms	4s704ms	5ms	23s550ms	34s834ms	58s748ms
	19	123,374	0ms	4s568ms	4ms	21s782ms	31s762ms	44s707ms
	20	128,438	0ms	4s892ms	6ms	38s465ms	43s100ms	54s122ms
	21	137,936	0ms	4s745ms	6ms	31s237ms	38s951ms	1m12s
	22	148,754	0ms	4s645ms	3ms	21s767ms	36s28ms	43s738ms
	23	173,461	0ms	4s585ms	3ms	28s761ms	31s699ms	41s691ms
Dec 08	00	168,402	0ms	40s841ms	2ms	16s53ms	31s136ms	1m3s
	01	180,904	0ms	3s20ms	2ms	14s26ms	32s865ms	48s785ms
	02	187,450	0ms	102ms	1ms	14s139ms	29s33ms	32s773ms
	03	197,609	0ms	101ms	1ms	14s403ms	29s879ms	36s18ms
	04	207,838	0ms	101ms	1ms	14s558ms	30s56ms	36s550ms
	05	214,571	0ms	111ms	1ms	14s910ms	31s305ms	35s711ms
	06	216,098	0ms	121ms	1ms	14s733ms	24s967ms	43s541ms
	07	217,873	0ms	4s543ms	1ms	14s519ms	35s175ms	38s149ms
	08	220,227	0ms	583ms	1ms	14s524ms	27s468ms	41s241ms
	09	218,055	0ms	938ms	1ms	14s955ms	31s662ms	34s569ms
	10	217,777	0ms	102ms	1ms	14s421ms	26s940ms	30s336ms
	11	218,436	0ms	248ms	1ms	14s594ms	27s312ms	30s46ms
	12	222,356	0ms	794ms	1ms	14s748ms	28s872ms	44s547ms
	13	217,762	0ms	112ms	1ms	13s687ms	26s817ms	33s73ms
	14	217,832	0ms	100ms	1ms	14s344ms	28s704ms	31s661ms
	15	219,920	0ms	446ms	1ms	14s318ms	27s890ms	39s381ms
	16	217,308	0ms	101ms	1ms	13s915ms	23s667ms	28s731ms
	17	218,902	0ms	951ms	1ms	16s249ms	34s769ms	39s736ms
	18	220,504	0ms	767ms	1ms	13s72ms	28s443ms	32s775ms
	19	217,747	0ms	107ms	1ms	13s742ms	18s373ms	29s590ms
	20	217,177	0ms	101ms	1ms	14s379ms	27s366ms	32s273ms
	21	219,995	0ms	3s603ms	1ms	14s295ms	23s133ms	27s990ms
	22	218,289	0ms	105ms	1ms	15s771ms	25s260ms	33s727ms
	23	234,387	0ms	967ms	2ms	21s88ms	28s434ms	42s283ms
Dec 09	00	224,464	0ms	32s330ms	1ms	16s376ms	36s907ms	40s820ms
	01	218,852	0ms	1s445ms	1ms	15s660ms	30s551ms	36s810ms
	02	219,274	0ms	1s339ms	1ms	15s28ms	26s906ms	32s410ms
	03	218,465	0ms	108ms	1ms	15s57ms	27s69ms	35s141ms
	04	220,672	0ms	109ms	1ms	21s76ms	36s221ms	39s733ms
	05	219,088	0ms	251ms	1ms	16s615ms	26s246ms	34s523ms
	06	224,657	0ms	1s69ms	1ms	17s883ms	40s800ms	44s872ms
	07	218,425	0ms	101ms	1ms	14s567ms	29s499ms	32s960ms
	08	218,426	0ms	753ms	1ms	15s157ms	29s837ms	35s305ms
	09	218,366	0ms	535ms	1ms	14s583ms	25s300ms	34s39ms
	10	217,778	0ms	104ms	1ms	14s37ms	29s980ms	33s331ms
	11	218,625	0ms	107ms	1ms	15s224ms	30s740ms	31s620ms
	12	217,713	0ms	732ms	1ms	14s986ms	25s584ms	32s343ms
	13	236,743	0ms	3s583ms	1ms	16s599ms	35s193ms	39s783ms
	14	235,121	0ms	115ms	1ms	15s658ms	30s607ms	39s125ms
	15	232,745	0ms	119ms	1ms	15s539ms	30s648ms	34s274ms
	16	235,057	0ms	763ms	1ms	15s426ms	32s703ms	38s279ms
	17	235,315	0ms	147ms	1ms	15s888ms	31s211ms	36s114ms
	18	234,222	0ms	1s326ms	1ms	16s144ms	31s833ms	33s618ms
	19	233,028	0ms	100ms	1ms	15s497ms	30s699ms	33s276ms
	20	233,668	0ms	100ms	1ms	15s730ms	33s679ms	35s20ms
	21	233,970	0ms	104ms	1ms	15s443ms	27s770ms	32s516ms
	22	234,753	0ms	105ms	1ms	15s968ms	30s681ms	33s452ms
	23	247,073	0ms	107ms	2ms	21s984ms	30s875ms	36s273ms
Dec 10	00	1	0ms	0ms	0ms	0ms	0ms	0ms
Dec 11	00	906,958	0ms	25s161ms	12ms	3m33s	3m41s	3m45s
	01	844,781	0ms	1s726ms	12ms	3m18s	3m21s	3m27s
	02	903,811	0ms	1s772ms	12ms	3m19s	3m25s	3m46s
	03	949,068	0ms	1s767ms	11ms	3m31s	3m34s	3m38s
	04	331,982	0ms	2s381ms	11ms	1m53s	2m58s	3m30s
	05	312,192	0ms	2m37s	20ms	4m1s	5m1s	6m50s
	06	474,822	0ms	2m30s	17ms	4m7s	4m48s	8m9s
	07	630,441	0ms	3m8s	19ms	5m13s	13m14s	16m29s
	08	778,195	0ms	1m55s	14ms	4m8s	5m28s	6m35s
	09	821,617	0ms	1m29s	13ms	4m19s	4m48s	7m3s
	10	846,054	0ms	1m19s	15ms	3m55s	9m17s	22m11s
	11	897,361	0ms	7s135ms	12ms	3m17s	3m28s	4m11s
	12	944,294	0ms	1s786ms	13ms	3m47s	3m51s	4m3s
	13	935,923	0ms	1m25s	12ms	3m52s	4m21s	4m25s
	14	947,364	0ms	1m13s	12ms	3m27s	3m36s	4m17s
	15	927,313	0ms	2s585ms	12ms	3m24s	3m27s	3m30s
	16	951,387	0ms	1m26s	13ms	3m55s	4m21s	6m1s
	17	930,853	0ms	2s486ms	12ms	3m32s	3m44s	4m13s
	18	870,350	0ms	1m7s	12ms	3m18s	3m37s	4m42s
	19	803,912	0ms	1s782ms	11ms	2m48s	2m52s	3m3s
	20	815,588	0ms	2s519ms	12ms	2m56s	2m59s	3m10s
	21	840,466	0ms	1s770ms	12ms	3m15s	3m18s	3m24s
	22	835,036	0ms	1s866ms	12ms	3m	3m11s	3m19s
	23	872,397	0ms	58s994ms	13ms	3m14s	6m51s	13m24s
Dec 12	00	1	0ms	0ms	0ms	0ms	0ms	0ms

Day	Hour	SELECT	COPY TO	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 06	00	234	0	649ms	3s125ms	5s46ms	9s321ms
	01	182	0	600ms	2s163ms	2s600ms	6s42ms
	02	143	0	569ms	2s169ms	2s657ms	4s764ms
	03	143	0	612ms	2s536ms	2s804ms	4s894ms
	04	56	0	1s74ms	521ms	1s527ms	4s379ms
	05	1,509	0	3s325ms	7s746ms	39s301ms	10m45s
	06	292	0	1s452ms	5s626ms	13s449ms	1m8s
	07	280	0	1s261ms	7s563ms	9s967ms	1m1s
	08	136	0	576ms	2s127ms	5s96ms	6s6ms
	09	286	0	494ms	3s721ms	4s842ms	12s747ms
	10	257	0	946ms	2s117ms	4s616ms	46s224ms
	11	108	0	629ms	1s649ms	3s242ms	3s892ms
	12	145	0	591ms	2s316ms	3s293ms	6s546ms
	13	232	0	551ms	3s533ms	4s235ms	7s932ms
	14	280	0	947ms	2s209ms	3s460ms	52s158ms
	15	68	0	656ms	1s708ms	2s99ms	3s202ms
	16	104	0	587ms	2s71ms	2s558ms	3s218ms
	17	89	0	659ms	1s722ms	2s484ms	4s344ms
	18	90	0	639ms	1s728ms	2s356ms	3s438ms
	19	111	0	612ms	2s115ms	2s675ms	3s587ms
	20	298	0	938ms	1s668ms	2s543ms	4s773ms
	21	188	0	856ms	1s722ms	2s456ms	14s893ms
	22	65	0	596ms	1s283ms	1s797ms	2s395ms
	23	77	0	595ms	1s480ms	1s768ms	2s845ms
Dec 07	00	263	0	2s236ms	18s836ms	33s275ms	1m14s
	01	147	0	596ms	2s176ms	4s26ms	8s400ms
	02	634	0	2s331ms	3s493ms	10s643ms	3m50s
	03	86	0	679ms	2s28ms	2s831ms	3s436ms
	04	13	0	1s77ms	0ms	1s1ms	2s384ms
	05	1,330	0	1s815ms	3s151ms	27s54ms	13m35s
	06	963	0	806ms	3s132ms	31s129ms	3m15s
	07	322	0	661ms	6s600ms	8s414ms	13s431ms
	08	482	1	557ms	3s732ms	9s405ms	41s202ms
	09	323	0	1s58ms	4s855ms	11s111ms	33s787ms
	10	98	0	1s457ms	2s525ms	4s792ms	19s950ms
	11	93	0	802ms	2s78ms	2s902ms	5s571ms
	12	437	0	769ms	2s978ms	14s432ms	54s14ms
	13	95	0	2s140ms	2s350ms	4s508ms	47s885ms
	14	105	0	2s630ms	9s66ms	16s448ms	28s10ms
	15	82	0	2s356ms	4s518ms	13s314ms	20s379ms
	16	125	0	2s55ms	7s512ms	13s465ms	28s777ms
	17	24	0	2s511ms	0ms	4s567ms	9s75ms
	18	13	0	3s126ms	0ms	0ms	9s386ms
	19	15	0	2s710ms	0ms	2s198ms	12s442ms
	20	193	0	2s266ms	11s998ms	22s617ms	39s955ms
	21	156	0	2s785ms	13s801ms	19s626ms	32s201ms
	22	26	0	3s407ms	4s551ms	4s590ms	7s308ms
	23	7	0	3s77ms	0ms	1s95ms	4s560ms
Dec 08	00	0	0	0ms	0ms	0ms	0ms
	01	5	0	1s312ms	0ms	0ms	0ms
	02	0	0	0ms	0ms	0ms	0ms
	03	0	0	0ms	0ms	0ms	0ms
	04	0	0	0ms	0ms	0ms	0ms
	05	0	0	0ms	0ms	0ms	0ms
	06	0	0	0ms	0ms	0ms	0ms
	07	2	0	4s80ms	0ms	0ms	0ms
	08	1	0	583ms	0ms	0ms	0ms
	09	4	0	585ms	0ms	0ms	357ms
	10	0	0	0ms	0ms	0ms	0ms
	11	0	0	0ms	0ms	0ms	0ms
	12	2	0	680ms	0ms	0ms	0ms
	13	0	0	0ms	0ms	0ms	0ms
	14	0	0	0ms	0ms	0ms	0ms
	15	1	0	446ms	0ms	0ms	0ms
	16	0	0	0ms	0ms	0ms	0ms
	17	63	0	546ms	663ms	1s426ms	7s566ms
	18	1	0	767ms	0ms	0ms	0ms
	19	0	0	0ms	0ms	0ms	0ms
	20	0	0	0ms	0ms	0ms	0ms
	21	6	0	1s248ms	0ms	0ms	0ms
	22	0	0	0ms	0ms	0ms	0ms
	23	1	0	967ms	0ms	0ms	0ms
Dec 09	00	2	0	570ms	0ms	0ms	440ms
	01	1	0	1s445ms	0ms	0ms	0ms
	02	4	0	601ms	0ms	0ms	0ms
	03	0	0	0ms	0ms	0ms	0ms
	04	0	0	0ms	0ms	0ms	0ms
	05	0	0	0ms	0ms	0ms	0ms
	06	7	0	577ms	0ms	0ms	0ms
	07	0	0	0ms	0ms	0ms	0ms
	08	19	0	514ms	337ms	639ms	1s252ms
	09	5	0	432ms	0ms	0ms	535ms
	10	0	0	0ms	0ms	0ms	0ms
	11	0	0	0ms	0ms	0ms	0ms
	12	11	0	526ms	0ms	0ms	1s419ms
	13	2	0	2s101ms	0ms	0ms	0ms
	14	0	0	0ms	0ms	0ms	0ms
	15	0	0	0ms	0ms	0ms	0ms
	16	3	0	601ms	0ms	0ms	0ms
	17	0	0	0ms	0ms	0ms	0ms
	18	4	0	598ms	0ms	0ms	0ms
	19	0	0	0ms	0ms	0ms	0ms
	20	0	0	0ms	0ms	0ms	0ms
	21	0	0	0ms	0ms	0ms	0ms
	22	0	0	0ms	0ms	0ms	0ms
	23	0	0	0ms	0ms	0ms	0ms
Dec 10	00	0	0	0ms	0ms	0ms	0ms
Dec 11	00	78	0	596ms	1s110ms	2s167ms	2s988ms
	01	81	0	574ms	1s205ms	1s872ms	3s279ms
	02	76	0	590ms	1s130ms	1s730ms	3s191ms
	03	58	0	722ms	1s195ms	1s767ms	3s430ms
	04	8	0	895ms	0ms	422ms	1s455ms
	05	279	0	767ms	3s825ms	10s606ms	23s782ms
	06	155	0	1s128ms	4s161ms	8s516ms	27s764ms
	07	440	0	1s215ms	8s133ms	27s923ms	1m34s
	08	800	0	795ms	3s251ms	34s364ms	2m12s
	09	274	0	1s120ms	2s187ms	3s276ms	1m24s
	10	1,072	0	1s812ms	3s81ms	52s637ms	6m15s
	11	212	0	740ms	1s723ms	2s156ms	46s561ms
	12	80	0	631ms	1s493ms	2s387ms	3s94ms
	13	99	0	706ms	1s987ms	2s721ms	3s916ms
	14	150	0	614ms	2s630ms	3s379ms	4s925ms
	15	198	0	644ms	3s483ms	4s776ms	7s19ms
	16	479	0	617ms	3s674ms	14s416ms	42s291ms
	17	145	0	630ms	2s146ms	3s295ms	9s59ms
	18	224	0	657ms	1s698ms	2s232ms	40s631ms
	19	44	0	662ms	1s41ms	1s718ms	2s153ms
	20	145	0	640ms	1s125ms	1s764ms	21s696ms
	21	59	0	720ms	1s499ms	2s184ms	2s471ms
	22	53	0	808ms	1s731ms	2s165ms	2s596ms
	23	429	0	2s180ms	1s456ms	2s534ms	3m48s
Dec 12	00	0	0	0ms	0ms	0ms	0ms

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 06	00	3	21	2	1	2s331ms	0ms	595ms	1s579ms
	01	7	8	0	0	754ms	0ms	0ms	1s297ms
	02	2	8	1	0	545ms	0ms	0ms	812ms
	03	0	9	0	0	514ms	0ms	0ms	819ms
	04	238	11	0	16	781ms	2s431ms	7s199ms	12s50ms
	05	421	2,063	97	109	1s838ms	1m5s	1m44s	5m9s
	06	226	1,245	20	72	1s349ms	8s180ms	1m7s	3m57s
	07	87	302	6	33	1s554ms	2s424ms	6s975ms	1m13s
	08	104	119	1	23	1s609ms	1s750ms	4s371ms	1m9s
	09	106	699	7	20	1s594ms	2s332ms	6s938ms	1m45s
	10	120	128	1	11	1s422ms	1s644ms	3s479ms	1m3s
	11	90	46	1	7	1s97ms	1s619ms	1s645ms	4s64ms
	12	11	115	0	11	1s675ms	331ms	1s616ms	45s110ms
	13	6	18	1	3	563ms	0ms	546ms	1s572ms
	14	4	24	0	0	864ms	0ms	0ms	2s732ms
	15	0	0	0	2	332ms	0ms	0ms	0ms
	16	0	4	0	1	13s295ms	0ms	0ms	326ms
	17	0	0	0	2	354ms	0ms	0ms	0ms
	18	6	4	0	2	674ms	0ms	0ms	808ms
	19	30	5	0	3	730ms	0ms	721ms	3s232ms
	20	5	28	4	0	795ms	0ms	414ms	937ms
	21	48	11	0	1	1s37ms	0ms	0ms	8s917ms
	22	1	0	0	1	595ms	0ms	0ms	0ms
	23	31	12	0	2	2s281ms	0ms	0ms	11s312ms
Dec 07	00	1	1	1	1	10s868ms	0ms	0ms	795ms
	01	2	8	4	1	568ms	0ms	0ms	1s20ms
	02	0	120	1	0	1s339ms	0ms	328ms	2s21ms
	03	24	0	0	1	792ms	0ms	802ms	1s628ms
	04	251	0	0	13	782ms	2s426ms	6s422ms	11s974ms
	05	132	1,434	61	94	1s619ms	21s392ms	1m27s	4m1s
	06	328	2,152	47	62	1s581ms	33s91ms	1m36s	7m22s
	07	50	2,542	19	56	1s230ms	28s814ms	1m21s	3m15s
	08	55	1,033	10	27	1s36ms	3s727ms	14s257ms	2m10s
	09	31	93	1	22	1s562ms	1s433ms	2s290ms	14s732ms
	10	43	187	0	16	1s536ms	1s612ms	2s464ms	1m9s
	11	19	0	0	6	723ms	0ms	453ms	1s630ms
	12	2	61	2	5	1s679ms	0ms	809ms	7s22ms
	13	0	0	0	2	345ms	0ms	0ms	0ms
	14	0	0	0	3	396ms	0ms	0ms	328ms
	15	0	0	0	0	0ms	0ms	0ms	0ms
	16	4	0	0	3	623ms	0ms	0ms	421ms
	17	0	0	0	0	0ms	0ms	0ms	0ms
	18	4	0	0	1	782ms	0ms	0ms	0ms
	19	0	0	0	0	0ms	0ms	0ms	0ms
	20	0	0	0	0	0ms	0ms	0ms	0ms
	21	0	0	0	0	0ms	0ms	0ms	0ms
	22	0	0	0	0	0ms	0ms	0ms	0ms
	23	0	0	0	0	0ms	0ms	0ms	0ms
Dec 08	00	0	0	1	0	40s841ms	0ms	0ms	0ms
	01	0	0	0	0	0ms	0ms	0ms	0ms
	02	0	0	0	0	0ms	0ms	0ms	0ms
	03	0	0	0	0	0ms	0ms	0ms	0ms
	04	0	0	0	0	0ms	0ms	0ms	0ms
	05	0	0	0	0	0ms	0ms	0ms	0ms
	06	0	0	0	0	0ms	0ms	0ms	0ms
	07	0	0	0	0	0ms	0ms	0ms	0ms
	08	0	1	0	0	418ms	0ms	0ms	0ms
	09	1	0	0	0	705ms	0ms	0ms	0ms
	10	0	0	0	0	0ms	0ms	0ms	0ms
	11	0	0	0	0	0ms	0ms	0ms	0ms
	12	0	0	0	0	0ms	0ms	0ms	0ms
	13	0	0	0	0	0ms	0ms	0ms	0ms
	14	0	0	0	0	0ms	0ms	0ms	0ms
	15	0	0	0	0	0ms	0ms	0ms	0ms
	16	0	0	0	0	0ms	0ms	0ms	0ms
	17	0	4	1	0	471ms	0ms	0ms	435ms
	18	0	0	0	0	0ms	0ms	0ms	0ms
	19	0	0	0	0	0ms	0ms	0ms	0ms
	20	0	0	0	0	0ms	0ms	0ms	0ms
	21	0	2	0	0	682ms	0ms	0ms	0ms
	22	0	0	0	0	0ms	0ms	0ms	0ms
	23	0	0	0	0	0ms	0ms	0ms	0ms
Dec 09	00	0	0	1	0	32s330ms	0ms	0ms	0ms
	01	0	0	0	0	0ms	0ms	0ms	0ms
	02	0	0	0	0	0ms	0ms	0ms	0ms
	03	0	0	0	0	0ms	0ms	0ms	0ms
	04	0	0	0	0	0ms	0ms	0ms	0ms
	05	0	0	0	0	0ms	0ms	0ms	0ms
	06	0	0	0	1	713ms	0ms	0ms	0ms
	07	0	0	0	0	0ms	0ms	0ms	0ms
	08	0	0	0	0	0ms	0ms	0ms	0ms
	09	0	0	0	0	0ms	0ms	0ms	0ms
	10	0	0	0	0	0ms	0ms	0ms	0ms
	11	0	0	0	0	0ms	0ms	0ms	0ms
	12	0	2	0	1	479ms	0ms	0ms	345ms
	13	0	0	0	0	0ms	0ms	0ms	0ms
	14	0	0	0	0	0ms	0ms	0ms	0ms
	15	0	0	0	0	0ms	0ms	0ms	0ms
	16	0	0	0	0	0ms	0ms	0ms	0ms
	17	0	0	0	0	0ms	0ms	0ms	0ms
	18	0	0	0	1	718ms	0ms	0ms	0ms
	19	0	0	0	0	0ms	0ms	0ms	0ms
	20	0	0	0	0	0ms	0ms	0ms	0ms
	21	0	0	0	0	0ms	0ms	0ms	0ms
	22	0	0	0	0	0ms	0ms	0ms	0ms
	23	0	0	0	0	0ms	0ms	0ms	0ms
Dec 10	00	0	0	0	0	0ms	0ms	0ms	0ms
Dec 11	00	18	0	1	1	2s16ms	0ms	796ms	1s601ms
	01	21	0	0	0	803ms	0ms	794ms	1s612ms
	02	10	1	0	0	815ms	0ms	0ms	945ms
	03	0	0	0	0	0ms	0ms	0ms	0ms
	04	250	0	0	8	782ms	3s48ms	4s802ms	15s947ms
	05	187	1,538	30	96	1s336ms	19s805ms	1m22s	3m12s
	06	132	1,640	26	71	1s78ms	17s17ms	1m12s	2m30s
	07	60	2,146	23	59	1s525ms	15s320ms	1m26s	6m19s
	08	73	468	12	27	1s302ms	3s894ms	13s557ms	1m21s
	09	88	440	0	19	1s588ms	4s18ms	19s187ms	1m23s
	10	96	381	1	13	1s124ms	2s387ms	3s298ms	1m1s
	11	34	11	0	12	657ms	448ms	1s584ms	2s310ms
	12	11	0	0	6	668ms	0ms	0ms	1s617ms
	13	3	122	0	6	1s834ms	0ms	641ms	23s25ms
	14	15	20	0	1	2s730ms	0ms	781ms	2s599ms
	15	25	17	2	1	712ms	371ms	1s572ms	1s628ms
	16	16	51	8	3	2s603ms	372ms	1s609ms	4s466ms
	17	21	7	2	1	710ms	0ms	815ms	1s605ms
	18	21	17	3	3	2s145ms	0ms	818ms	3s202ms
	19	64	14	0	1	783ms	791ms	1s608ms	5s625ms
	20	60	23	1	2	807ms	809ms	1s611ms	6s332ms
	21	63	0	0	0	802ms	796ms	1s617ms	3s221ms
	22	57	0	0	0	801ms	0ms	1s601ms	3s987ms
	23	60	136	1	2	1s115ms	813ms	1s636ms	35s337ms
Dec 12	00	0	0	0	0	0ms	0ms	0ms	0ms

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
Dec 06	00	0	2	2.00	0.00%
	01	0	0	0.00	0.00%
	02	0	0	0.00	0.00%
	03	0	0	0.00	0.00%
	04	0	0	0.00	0.00%
	05	0	9	9.00	0.00%
	06	0	0	0.00	0.00%
	07	0	0	0.00	0.00%
	08	0	0	0.00	0.00%
	09	0	0	0.00	0.00%
	10	0	18	18.00	0.00%
	11	0	12	12.00	0.00%
	12	0	0	0.00	0.00%
	13	0	1	1.00	0.00%
	14	0	0	0.00	0.00%
	15	0	1	1.00	0.00%
	16	0	0	0.00	0.00%
	17	0	0	0.00	0.00%
	18	0	0	0.00	0.00%
	19	0	0	0.00	0.00%
	20	0	9	9.00	0.00%
	21	0	36	36.00	0.00%
	22	0	0	0.00	0.00%
	23	0	0	0.00	0.00%
Dec 07	00	0	3	3.00	0.00%
	01	0	0	0.00	0.00%
	02	0	0	0.00	0.00%
	03	0	0	0.00	0.00%
	04	0	0	0.00	0.00%
	05	0	0	0.00	0.00%
	06	1	20	20.00	0.03%
	07	0	0	0.00	0.00%
	08	0	1	1.00	0.00%
	09	0	26	26.00	0.00%
	10	0	0	0.00	0.00%
	11	0	0	0.00	0.00%
	12	0	14	14.00	0.00%
	13	0	0	0.00	0.00%
	14	0	0	0.00	0.00%
	15	0	0	0.00	0.00%
	16	0	0	0.00	0.00%
	17	0	0	0.00	0.00%
	18	0	0	0.00	0.00%
	19	0	0	0.00	0.00%
	20	0	10	10.00	0.00%
	21	0	0	0.00	0.00%
	22	0	0	0.00	0.00%
	23	0	0	0.00	0.00%
Dec 08	00	0	0	0.00	0.00%
	01	0	2	2.00	0.00%
	02	0	0	0.00	0.00%
	03	0	0	0.00	0.00%
	04	0	0	0.00	0.00%
	05	0	0	0.00	0.00%
	06	0	0	0.00	0.00%
	07	0	2	2.00	0.00%
	08	1	0	0.00	50.00%
	09	0	0	0.00	0.00%
	10	0	0	0.00	0.00%
	11	0	0	0.00	0.00%
	12	0	0	0.00	0.00%
	13	0	0	0.00	0.00%
	14	0	0	0.00	0.00%
	15	0	1	1.00	0.00%
	16	0	0	0.00	0.00%
	17	0	0	0.00	0.00%
	18	0	0	0.00	0.00%
	19	0	0	0.00	0.00%
	20	0	0	0.00	0.00%
	21	0	1	1.00	0.00%
	22	0	0	0.00	0.00%
	23	0	0	0.00	0.00%
Dec 09	00	1	0	0.00	33.33%
	01	0	1	1.00	0.00%
	02	0	4	4.00	0.00%
	03	0	0	0.00	0.00%
	04	0	0	0.00	0.00%
	05	0	0	0.00	0.00%
	06	0	0	0.00	0.00%
	07	0	0	0.00	0.00%
	08	0	0	0.00	0.00%
	09	0	0	0.00	0.00%
	10	0	0	0.00	0.00%
	11	0	0	0.00	0.00%
	12	0	0	0.00	0.00%
	13	0	1	1.00	0.00%
	14	0	0	0.00	0.00%
	15	0	0	0.00	0.00%
	16	0	0	0.00	0.00%
	17	0	0	0.00	0.00%
	18	0	4	4.00	0.00%
	19	0	0	0.00	0.00%
	20	0	0	0.00	0.00%
	21	0	0	0.00	0.00%
	22	0	0	0.00	0.00%
	23	0	0	0.00	0.00%
Dec 10	00	0	0	0.00	0.00%
Dec 11	00	0	0	0.00	0.00%
	01	0	0	0.00	0.00%
	02	0	0	0.00	0.00%
	03	0	4	4.00	0.00%
	04	0	0	0.00	0.00%
	05	0	0	0.00	0.00%
	06	0	2	2.00	0.00%
	07	0	4	4.00	0.00%
	08	0	82	82.00	0.00%
	09	0	24	24.00	0.00%
	10	0	8	8.00	0.00%
	11	0	18	18.00	0.00%
	12	0	1	1.00	0.00%
	13	0	0	0.00	0.00%
	14	0	0	0.00	0.00%
	15	0	0	0.00	0.00%
	16	0	0	0.00	0.00%
	17	0	0	0.00	0.00%
	18	0	51	51.00	0.00%
	19	0	0	0.00	0.00%
	20	0	0	0.00	0.00%
	21	0	0	0.00	0.00%
	22	0	1	1.00	0.00%
	23	0	19	19.00	0.00%
Dec 12	00	0	0	0.00	0.00%

Day	Hour	Count	Average / Second
Dec 06	00	179,565	49.88/s
	01	183,511	50.98/s
	02	199,758	55.49/s
	03	208,182	57.83/s
	04	58,074	16.13/s
	05	44,235	12.29/s
	06	44,705	12.42/s
	07	108,894	30.25/s
	08	147,255	40.90/s
	09	162,329	45.09/s
	10	180,147	50.04/s
	11	184,412	51.23/s
	12	177,836	49.40/s
	13	189,339	52.59/s
	14	169,587	47.11/s
	15	188,939	52.48/s
	16	190,476	52.91/s
	17	195,961	54.43/s
	18	190,636	52.95/s
	19	196,338	54.54/s
	20	192,786	53.55/s
	21	191,844	53.29/s
	22	192,732	53.54/s
	23	191,199	53.11/s
Dec 07	00	194,869	54.13/s
	01	192,356	53.43/s
	02	205,311	57.03/s
	03	205,475	57.08/s
	04	62,092	17.25/s
	05	46,561	12.93/s
	06	51,599	14.33/s
	07	110,626	30.73/s
	08	132,129	36.70/s
	09	157,066	43.63/s
	10	171,138	47.54/s
	11	184,797	51.33/s
	12	175,268	48.69/s
	13	177,802	49.39/s
	14	58,427	16.23/s
	15	11,147	3.10/s
	16	16,497	4.58/s
	17	21,217	5.89/s
	18	13,482	3.75/s
	19	8,668	2.41/s
	20	8,637	2.40/s
	21	8,801	2.44/s
	22	8,873	2.46/s
	23	9,163	2.55/s
Dec 08	00	8,799	2.44/s
	01	8,900	2.47/s
	02	9,118	2.53/s
	03	9,174	2.55/s
	04	9,455	2.63/s
	05	9,753	2.71/s
	06	9,954	2.77/s
	07	9,426	2.62/s
	08	9,426	2.62/s
	09	9,628	2.67/s
	10	9,519	2.64/s
	11	9,626	2.67/s
	12	9,578	2.66/s
	13	9,451	2.63/s
	14	9,593	2.66/s
	15	9,303	2.58/s
	16	9,394	2.61/s
	17	9,820	2.73/s
	18	9,247	2.57/s
	19	9,454	2.63/s
	20	9,334	2.59/s
	21	9,508	2.64/s
	22	9,616	2.67/s
	23	9,983	2.77/s
Dec 09	00	9,705	2.70/s
	01	9,706	2.70/s
	02	9,613	2.67/s
	03	9,683	2.69/s
	04	9,779	2.72/s
	05	9,826	2.73/s
	06	9,957	2.77/s
	07	9,557	2.65/s
	08	9,588	2.66/s
	09	9,810	2.73/s
	10	9,543	2.65/s
	11	9,523	2.65/s
	12	9,634	2.68/s
	13	22,225	6.17/s
	14	23,709	6.59/s
	15	23,617	6.56/s
	16	23,314	6.48/s
	17	23,887	6.64/s
	18	23,265	6.46/s
	19	23,135	6.43/s
	20	22,842	6.34/s
	21	22,921	6.37/s
	22	23,016	6.39/s
	23	23,121	6.42/s
Dec 10	00	0	0.00/s
Dec 11	00	185,352	51.49/s
	01	173,266	48.13/s
	02	194,052	53.90/s
	03	198,828	55.23/s
	04	60,161	16.71/s
	05	60,950	16.93/s
	06	100,550	27.93/s
	07	126,610	35.17/s
	08	154,868	43.02/s
	09	173,458	48.18/s
	10	174,471	48.46/s
	11	188,763	52.43/s
	12	196,860	54.68/s
	13	198,287	55.08/s
	14	204,929	56.92/s
	15	200,100	55.58/s
	16	198,888	55.25/s
	17	195,206	54.22/s
	18	182,668	50.74/s
	19	168,365	46.77/s
	20	166,504	46.25/s
	21	171,068	47.52/s
	22	169,710	47.14/s
	23	175,650	48.79/s
Dec 12	00	0	0.00/s

Day	Hour	Count	Average Duration
Dec 06	00	179,564	6s6ms
	01	183,511	5s885ms
	02	199,758	5s408ms
	03	208,184	5s181ms
	04	58,073	18s333ms
	05	44,235	24s420ms
	06	44,704	24s235ms
	07	108,894	9s988ms
	08	147,255	7s332ms
	09	162,331	6s653ms
	10	180,145	5s993ms
	11	184,412	5s844ms
	12	177,836	6s72ms
	13	189,339	5s707ms
	14	169,588	5s958ms
	15	188,939	5s706ms
	16	190,475	5s667ms
	17	195,961	5s514ms
	18	190,636	5s653ms
	19	196,338	5s500ms
	20	192,787	5s589ms
	21	191,843	5s632ms
	22	192,732	5s594ms
	23	191,199	5s640ms
Dec 07	00	194,869	5s546ms
	01	192,356	5s610ms
	02	205,311	5s258ms
	03	205,476	5s245ms
	04	62,091	17s218ms
	05	46,561	23s166ms
	06	51,599	21s49ms
	07	110,628	9s811ms
	08	132,127	8s168ms
	09	157,066	6s871ms
	10	171,138	6s305ms
	11	184,797	5s834ms
	12	175,269	6s160ms
	13	177,801	6s74ms
	14	58,497	16s499ms
	15	11,079	1m28s
	16	16,504	1m4s
	17	21,211	50s68ms
	18	13,488	1m16s
	19	8,662	2m1s
	20	8,640	2m3s
	21	8,796	2m
	22	8,872	2m2s
	23	9,165	1m57s
Dec 08	00	8,797	2m
	01	8,900	2m1s
	02	9,118	1m58s
	03	9,174	1m57s
	04	9,455	1m54s
	05	9,753	1m51s
	06	9,954	1m50s
	07	9,426	1m51s
	08	9,426	1m54s
	09	9,628	1m52s
	10	9,519	1m53s
	11	9,626	1m52s
	12	9,578	1m52s
	13	9,451	1m54s
	14	9,593	1m52s
	15	9,303	1m55s
	16	9,394	1m54s
	17	9,820	1m49s
	18	9,247	1m56s
	19	9,454	1m54s
	20	9,334	1m56s
	21	9,508	1m52s
	22	9,616	1m51s
	23	9,983	1m48s
Dec 09	00	9,705	1m50s
	01	9,706	1m51s
	02	9,613	1m52s
	03	9,683	1m50s
	04	9,779	1m51s
	05	9,826	1m49s
	06	9,957	1m50s
	07	9,557	1m49s
	08	9,589	1m53s
	09	9,809	1m50s
	10	9,543	1m52s
	11	9,523	1m53s
	12	9,634	1m52s
	13	22,225	49s897ms
	14	23,709	45s483ms
	15	23,617	45s802ms
	16	23,315	46s197ms
	17	23,886	45s275ms
	18	23,265	46s356ms
	19	23,135	46s670ms
	20	22,842	47s417ms
	21	22,921	47s93ms
	22	23,017	46s837ms
	23	23,120	46s662ms
Dec 10	00	0	0ms
Dec 11	00	185,350	5s822ms
	01	173,266	6s229ms
	02	194,052	5s555ms
	03	198,829	5s431ms
	04	60,160	17s724ms
	05	60,950	17s851ms
	06	100,550	10s755ms
	07	126,610	8s543ms
	08	154,868	6s969ms
	09	173,458	6s225ms
	10	174,471	6s176ms
	11	188,763	5s725ms
	12	196,862	5s481ms
	13	198,285	5s445ms
	14	204,929	5s261ms
	15	200,100	5s393ms
	16	198,888	5s428ms
	17	195,207	5s522ms
	18	182,667	5s907ms
	19	168,365	6s410ms
	20	166,504	6s488ms
	21	171,068	6s307ms
	22	169,711	6s356ms
	23	175,649	6s143ms
Dec 12	00	0	0ms

↑ Back to the top of the General Activity table

Established Connections

Key values

266 connections Connection Peak
2012-12-07 02:02:02 Date

Connections per database

Key values

nightly Main Database
10,828,340 connections Total

Chart
Table

Database	User	Count
cbs		537,247
	lfriedman	537,247
inventory		699,040
	lfriedman	699,040
mbm		178,245
	lfriedman	178,245
nightly		9,332,073
	lfriedman	9,332,073
postgres		2,077
	postgres	2,077
pvs		79,658
	lfriedman	79,658

Connections per user

Key values

lfriedman Main User
10,828,340 connections Total

Chart
Table

User	Count
lfriedman	10,826,263
postgres	2,077

Connections per host

Key values

10.31.96.124 Main host with 8756056 connections
10,828,338 Total connections

Chart
Table

Host	Count
10.31.96.124	8,756,056
10.31.96.233	2,067,923
10.31.98.149	1,479
[local]	2,880

Simultaneous sessions

Key values

334 sessions Session Peak
2012-12-07 00:00:00 Date

Histogram of session times

Key values

6,761,444 1000-30000ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	3,011,509	27.81%
500ms-1s	479,223	4.43%
1s-30s	6,761,444	62.44%
30s-1m	291,639	2.69%
1m-10m	273,349	2.52%
10m-30m	11,108	0.10%
30m-1h	65	0.00%
1h-8h	0	0.00%
> 8h	0	0.00%

Sessions per database

Key values

nightly Main Database
10,828,337 sessions Total

Chart
Table

Database	User	Count	Total Duration
cbs	537,235	35d9h34m8s	5s692ms
inventory	698,811	630d19h29m59s	1m17s
mbm	178,234	14d19h59m6s	7s190ms
nightly	9,332,322	809d18h39m10s	7s497ms
postgres	2,077	17s286ms	8ms
pvs	79,658	3d21h30m43s	4s226ms

Sessions per user

Key values

lfriedman Main User
10,828,337 sessions Total

Chart
Table

User	Count	Total Duration	Average Duration
lfriedman	10,826,260	1494d17h13m7s
postgres	2,077	17s286ms

Sessions per host

Key values

10.31.96.124 Main Host
10,828,337 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
10.31.96.124	8,755,756	1319d18h46m29s	13s23ms
10.31.96.233	2,068,222	174d22h25m23s	7s307ms
10.31.98.149	1,479	53s496ms	36ms
[local]	2,880	38s534ms	13ms

Sessions per application

Key values

unknown Main Host
10,828,337 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
unknown	10,828,337	1494d17h13m24s	11s926ms

Checkpoints Buffers

Key values

182,507 buffers Checkpoint Peak
2012-12-07 06:24:34 Date
210.072 seconds Highest write time
156.589 seconds Sync time

Checkpoints Wal files

Key values

123 files Wal files usage Peak
2012-12-11 06:18:16 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Dec 06	00	74,044	2,349.262s	0.364s	2,349.682s
	01	21,331	2,129.491s	0.297s	2,129.844s
	02	19,894	1,988.969s	0.141s	1,989.176s
	03	20,799	2,078.716s	0.106s	2,078.879s
	04	56,217	2,460.352s	0.616s	2,461.038s
	05	1,380,983	2,136.503s	449.962s	2,586.666s
	06	1,093,540	2,009.882s	202.775s	2,212.86s
	07	546,752	2,541.818s	18.902s	2,560.821s
	08	464,954	2,467.27s	9.554s	2,476.92s
	09	467,312	2,353.665s	141.514s	2,495.286s
	10	270,953	2,292.833s	13.423s	2,306.355s
	11	293,010	2,641.008s	10.22s	2,651.306s
	12	289,064	1,994.243s	6.316s	2,000.751s
	13	25,869	2,470.542s	0.205s	2,470.808s
	14	22,277	2,209.586s	0.157s	2,209.816s
	15	22,327	2,206.005s	0.174s	2,206.236s
	16	142,113	2,103.11s	0.298s	2,103.47s
	17	26,177	2,516.635s	0.13s	2,516.838s
	18	23,151	2,225.367s	0.141s	2,225.562s
	19	21,116	2,046.125s	0.107s	2,046.283s
	20	24,964	2,442.415s	0.121s	2,442.603s
	21	19,617	1,959.431s	0.107s	1,959.596s
	22	23,582	2,324.538s	0.107s	2,324.711s
	23	145,464	2,166.001s	0.177s	2,166.241s
Dec 07	00	74,555	2,406.294s	0.413s	2,406.77s
	01	20,961	2,063.76s	0.178s	2,063.994s
	02	22,195	2,093.686s	0.104s	2,093.848s
	03	21,316	2,116.301s	0.102s	2,116.454s
	04	47,433	2,299.988s	0.58s	2,300.619s
	05	1,338,294	2,571.408s	305.761s	2,877.4s
	06	1,286,860	2,278.729s	287.058s	2,566.084s
	07	1,219,145	2,551.646s	241.282s	2,793.739s
	08	693,279	2,227.931s	132.918s	2,360.936s
	09	366,456	2,428.615s	14.108s	2,442.803s
	10	463,863	2,468.153s	12.607s	2,480.866s
	11	33,262	2,457.584s	0.274s	2,457.915s
	12	174,737	2,225.872s	2.732s	2,228.68s
	13	22,747	2,225.218s	0.15s	2,225.436s
	14	13,376	1,244.215s	0.14s	1,244.415s
	15	3,035	303.536s	0.189s	303.781s
	16	5,222	522.161s	0.187s	522.403s
	17	3,290	328.902s	0.126s	329.079s
	18	2,860	285.789s	0.135s	285.979s
	19	2,108	210.939s	0.095s	211.091s
	20	2,398	239.411s	0.087s	239.552s
	21	1,611	161.002s	0.092s	161.146s
	22	1,619	161.854s	0.09s	161.998s
	23	1,723	172.261s	0.107s	172.423s
Dec 08	00	52,573	334.335s	0.145s	334.536s
	01	1,869	186.691s	0.1s	186.847s
	02	1,500	149.768s	0.092s	149.916s
	03	2,283	228.231s	0.111s	228.396s
	04	1,965	196.373s	0.106s	196.534s
	05	1,805	180.342s	0.108s	180.504s
	06	1,740	173.927s	0.111s	174.089s
	07	2,058	205.73s	0.114s	205.9s
	08	1,776	177.659s	0.109s	177.823s
	09	1,702	170.255s	0.106s	170.412s
	10	1,735	173.258s	0.108s	173.419s
	11	1,784	178.24s	0.107s	178.402s
	12	1,908	190.664s	0.108s	190.827s
	13	1,789	178.74s	0.109s	178.9s
	14	1,784	178.333s	0.109s	178.498s
	15	2,085	208.498s	0.106s	208.655s
	16	1,719	171.726s	0.105s	171.886s
	17	1,774	177.328s	0.11s	177.493s
	18	1,784	178.334s	0.11s	178.494s
	19	1,794	179.372s	0.113s	179.539s
	20	1,755	175.363s	0.108s	175.525s
	21	1,742	174.049s	0.105s	174.21s
	22	1,815	181.478s	0.109s	181.639s
	23	2,006	200.307s	0.122s	200.485s
Dec 09	00	53,399	355.011s	0.154s	355.219s
	01	1,832	183.281s	0.101s	183.434s
	02	2,532	253.023s	0.099s	253.173s
	03	1,769	176.971s	0.109s	177.139s
	04	1,813	181.278s	0.11s	181.442s
	05	1,779	177.968s	0.111s	178.132s
	06	2,676	267.737s	0.104s	267.897s
	07	1,765	176.569s	0.105s	176.731s
	08	1,797	179.77s	0.112s	179.938s
	09	1,791	179.071s	0.108s	179.231s
	10	1,743	174.358s	0.108s	174.519s
	11	1,789	178.967s	0.107s	179.125s
	12	2,419	241.684s	0.103s	241.836s
	13	4,380	437.866s	0.119s	438.039s
	14	4,658	465.715s	0.121s	465.888s
	15	4,637	463.92s	0.117s	464.104s
	16	4,620	461.422s	0.126s	461.6s
	17	4,694	469.532s	0.121s	469.712s
	18	5,399	539.881s	0.119s	540.05s
	19	4,663	466.24s	0.142s	466.434s
	20	4,621	461.913s	0.139s	462.105s
	21	4,650	464.52s	0.131s	464.709s
	22	4,670	467.236s	0.125s	467.416s
	23	4,495	449.517s	0.125s	449.694s
Dec 10	00	0	0s	0s	0s
Dec 11	00	63,024	2,254.767s	0.219s	2,255.043s
	01	19,880	1,984.949s	0.161s	1,985.182s
	02	19,295	1,926.493s	0.097s	1,926.641s
	03	20,824	2,061.877s	0.092s	2,062.028s
	04	47,397	2,438.661s	0.596s	2,439.313s
	05	1,140,619	2,510.347s	289.766s	2,800.705s
	06	1,024,206	2,321.88s	414.408s	2,736.526s
	07	933,045	2,064.504s	277.526s	2,342.497s
	08	795,342	2,424.867s	27.603s	2,452.6s
	09	734,795	2,166.703s	19.068s	2,185.926s
	10	328,745	2,514.236s	8.971s	2,523.28s
	11	45,715	2,518.49s	0.294s	2,518.837s
	12	31,194	2,431.612s	0.157s	2,431.835s
	13	275,381	2,182.86s	5.614s	2,188.588s
	14	171,974	2,575.419s	0.567s	2,576.065s
	15	22,613	2,239.675s	0.128s	2,239.869s
	16	168,417	2,294.679s	0.188s	2,294.95s
	17	169,386	2,342.118s	0.263s	2,342.451s
	18	27,690	2,241.387s	0.141s	2,241.592s
	19	167,529	2,264.875s	0.29s	2,265.23s
	20	21,839	2,150.257s	0.128s	2,150.441s
	21	22,781	2,221.403s	0.122s	2,221.579s
	22	21,831	2,174.802s	0.121s	2,174.989s
	23	23,924	2,262.219s	0.106s	2,262.384s
Dec 12	00	0	0s	0s	0s

Day	Hour	Recycled	Synced files	Longest sync	Average sync
Dec 06	00	80	3,452	0.034s	0s
	01	58	2,583	0.003s	0s
	02	59	1,000	0.003s	0s
	03	59	681	0.008s	0s
	04	60	14,830	0.002s	0s
	05	650	19,436	26.340s	0.564s
	06	515	14,642	51.002s	0.222s
	07	300	12,133	3.992s	0.029s
	08	227	9,840	3.389s	0.011s
	09	244	7,137	25.743s	0.167s
	10	193	6,136	0.399s	0.021s
	11	115	4,574	5.482s	0.019s
	12	156	3,596	3.189s	0.011s
	13	64	2,561	0.007s	0s
	14	57	1,708	0.004s	0s
	15	58	1,514	0.002s	0s
	16	100	1,133	0.051s	0.001s
	17	64	1,964	0.007s	0s
	18	59	1,590	0.008s	0s
	19	54	1,014	0.008s	0s
	20	64	1,533	0.005s	0s
	21	54	718	0.003s	0s
	22	64	906	0.007s	0s
	23	106	795	0.042s	0s
Dec 07	00	81	3,852	0.026s	0s
	01	59	2,372	0.008s	0s
	02	58	1,071	0.003s	0s
	03	59	764	0.003s	0s
	04	55	12,289	0.007s	0s
	05	642	17,498	31.633s	0.277s
	06	586	13,744	24.497s	0.33s
	07	607	11,501	22.186s	0.336s
	08	289	11,595	22.709s	0.144s
	09	171	9,028	3.071s	0.017s
	10	229	6,135	3.763s	0.019s
	11	59	4,267	0.002s	0s
	12	113	4,381	2.218s	0.005s
	13	59	2,730	0.007s	0s
	14	60	1,447	0.002s	0s
	15	60	1,030	0.002s	0s
	16	59	1,350	0.007s	0s
	17	59	654	0.002s	0s
	18	59	548	0.009s	0s
	19	59	521	0.001s	0s
	20	58	410	0.003s	0s
	21	59	441	0.004s	0s
	22	59	442	0.001s	0s
	23	59	478	0.001s	0s
Dec 08	00	80	471	0.029s	0s
	01	59	513	0.001s	0s
	02	59	429	0.001s	0s
	03	59	490	0.005s	0s
	04	59	507	0.002s	0s
	05	59	489	0.002s	0s
	06	59	499	0.002s	0s
	07	59	587	0.001s	0s
	08	59	502	0.001s	0s
	09	59	481	0.001s	0s
	10	59	487	0.001s	0s
	11	59	489	0.001s	0s
	12	59	521	0.001s	0s
	13	59	493	0.001s	0s
	14	59	497	0.001s	0s
	15	59	534	0.002s	0s
	16	59	490	0.001s	0s
	17	59	494	0.001s	0s
	18	59	492	0.001s	0s
	19	59	492	0.008s	0s
	20	59	486	0.002s	0s
	21	58	490	0.001s	0s
	22	59	499	0s	0s
	23	60	549	0.002s	0s
Dec 09	00	80	522	0.008s	0s
	01	59	481	0s	0s
	02	59	502	0.002s	0s
	03	59	483	0.001s	0s
	04	59	500	0.001s	0s
	05	59	489	0.002s	0s
	06	59	553	0.002s	0s
	07	59	488	0.001s	0s
	08	59	499	0.002s	0s
	09	59	484	0.002s	0s
	10	59	493	0.001s	0s
	11	59	488	0.001s	0s
	12	59	542	0.001s	0s
	13	60	634	0.001s	0s
	14	58	625	0.002s	0s
	15	59	629	0.001s	0s
	16	59	646	0.001s	0s
	17	59	665	0.002s	0s
	18	59	720	0.001s	0s
	19	59	628	0.002s	0s
	20	59	639	0.002s	0s
	21	59	650	0.001s	0s
	22	59	641	0.002s	0s
	23	54	632	0.002s	0s
Dec 10	00	0	0	0s	0s
Dec 11	00	75	3,460	0.019s	0s
	01	58	2,750	0.007s	0s
	02	59	1,172	0.002s	0s
	03	60	809	0.005s	0s
	04	59	12,805	0.008s	0s
	05	590	19,436	31.639s	0.304s
	06	441	13,862	26.033s	0.365s
	07	454	10,620	45.205s	0.694s
	08	359	9,071	4.726s	0.038s
	09	396	6,337	5.391s	0.043s
	10	135	5,373	5.109s	0.025s
	11	59	4,474	0.007s	0s
	12	59	3,233	0.005s	0s
	13	175	2,654	1.714s	0.028s
	14	123	1,895	0.145s	0.006s
	15	59	1,343	0.007s	0s
	16	147	1,391	0.027s	0.001s
	17	90	2,510	0.029s	0s
	18	58	1,567	0.002s	0s
	19	120	1,171	0.087s	0.001s
	20	58	874	0.003s	0s
	21	59	998	0.007s	0s
	22	59	781	0.008s	0s
	23	60	890	0.004s	0s
Dec 12	00	0	0	0s	0s

Day	Hour	Avg time (sec)
Dec 06	00	0s
	01	0s
	02	0s
	03	0s
	04	0s
	05	0s
	06	0s
	07	0s
	08	0s
	09	0s
	10	0s
	11	0s
	12	0s
	13	0s
	14	0s
	15	0s
	16	0s
	17	0s
	18	0s
	19	0s
	20	0s
	21	0s
	22	0s
	23	0s
Dec 07	00	0s
	01	0s
	02	0s
	03	0s
	04	0s
	05	0s
	06	0s
	07	0s
	08	0s
	09	0s
	10	0s
	11	0s
	12	0s
	13	0s
	14	0s
	15	0s
	16	0s
	17	0s
	18	0s
	19	0s
	20	0s
	21	0s
	22	0s
	23	0s
Dec 08	00	0s
	01	0s
	02	0s
	03	0s
	04	0s
	05	0s
	06	0s
	07	0s
	08	0s
	09	0s
	10	0s
	11	0s
	12	0s
	13	0s
	14	0s
	15	0s
	16	0s
	17	0s
	18	0s
	19	0s
	20	0s
	21	0s
	22	0s
	23	0s
Dec 09	00	0s
	01	0s
	02	0s
	03	0s
	04	0s
	05	0s
	06	0s
	07	0s
	08	0s
	09	0s
	10	0s
	11	0s
	12	0s
	13	0s
	14	0s
	15	0s
	16	0s
	17	0s
	18	0s
	19	0s
	20	0s
	21	0s
	22	0s
	23	0s
Dec 10	00	0s
Dec 11	00	0s
	01	0s
	02	0s
	03	0s
	04	0s
	05	0s
	06	0s
	07	0s
	08	0s
	09	0s
	10	0s
	11	0s
	12	0s
	13	0s
	14	0s
	15	0s
	16	0s
	17	0s
	18	0s
	19	0s
	20	0s
	21	0s
	22	0s
	23	0s
Dec 12	00	0s

↑ Back to the top of the Checkpoint Activity table

Size of temporary files

Key values

24.55 MiB Temp Files Peak
2012-12-07 20:25:38 Date

Number of temporary files

Key values

2 per second Temp Files Peak
2012-12-07 20:25:38 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Dec 06	00	0	0
	01	0	0
	02	0	0
	03	0	0
	04	0	0
	05	0	0
	06	0	0
	07	0	0
	08	0	0
	09	0	0
	10	0	0
	11	0	0
	12	0	0
	13	0	0
	14	0	0
	15	0	0
	16	0	0
	17	0	0
	18	0	0
	19	0	0
	20	0	0
	21	0	0
	22	0	0
	23	0	0
Dec 07	00	10	122.97 MiB	12.30 MiB
	01	1	12.29 MiB	12.29 MiB
	02	0	0
	03	0	0
	04	0	0
	05	0	0
	06	0	0
	07	0	0
	08	0	0
	09	0	0
	10	4	49.12 MiB	12.28 MiB
	11	0	0
	12	0	0
	13	0	0
	14	7	85.91 MiB	12.27 MiB
	15	45	552.30 MiB	12.27 MiB
	16	37	454.17 MiB	12.27 MiB
	17	8	103.01 MiB	12.88 MiB
	18	2	10.56 MiB	5.28 MiB
	19	0	0
	20	65	755.73 MiB	11.63 MiB
	21	53	650.24 MiB	12.27 MiB
	22	3	36.80 MiB	12.27 MiB
	23	0	0
Dec 08	00	0	0
	01	0	0
	02	0	0
	03	0	0
	04	0	0
	05	0	0
	06	0	0
	07	0	0
	08	0	0
	09	0	0
	10	0	0
	11	0	0
	12	0	0
	13	0	0
	14	0	0
	15	0	0
	16	0	0
	17	0	0
	18	0	0
	19	0	0
	20	0	0
	21	0	0
	22	0	0
	23	0	0
Dec 09	00	0	0
	01	0	0
	02	0	0
	03	0	0
	04	0	0
	05	0	0
	06	0	0
	07	0	0
	08	0	0
	09	0	0
	10	0	0
	11	0	0
	12	0	0
	13	0	0
	14	0	0
	15	0	0
	16	0	0
	17	0	0
	18	0	0
	19	0	0
	20	0	0
	21	0	0
	22	0	0
	23	0	0
Dec 10	00	0	0
Dec 11	00	0	0
	01	0	0
	02	0	0
	03	0	0
	04	0	0
	05	0	0
	06	0	0
	07	0	0
	08	0	0
	09	0	0
	10	0	0
	11	0	0
	12	0	0
	13	0	0
	14	0	0
	15	0	0
	16	0	0
	17	0	0
	18	0	0
	19	0	0
	20	0	0
	21	0	0
	22	0	0
	23	0	0
Dec 12	00	0	0

↑ Back to the top of the Temporay Files Activity table

Queries generating the most temporary files (N)


Duration: 1s502msDatabase: team654User: team654
Duration: 1s486msDatabase: team654User: team654
Duration: 1s499msDatabase: team654User: team654
Duration: 1s497msDatabase: team654User: team654
Duration: 1s518msDatabase: team654User: team654

Duration: 1s698msDatabase: team654User: team654
Duration: 1s537msDatabase: team654User: team654

Duration: 1s458msDatabase: team654User: team654
Duration: 1s417msDatabase: team654User: team654
Duration: 1s421msDatabase: team654User: team654
Duration: 1s758msDatabase: team654User: team654
Duration: 1s448msDatabase: team654User: team654
Duration: 1s467msDatabase: team654User: team654
Duration: 1s523msDatabase: team654User: team654
Duration: 1s454msDatabase: team654User: team654
Duration: 1s435msDatabase: team654User: team654
Duration: 1s461msDatabase: team654User: team654
Duration: 1s450msDatabase: team654User: team654
Duration: 1s701msDatabase: team654User: team654

Duration: 1s688msDatabase: team654User: team654
Duration: 1s437msDatabase: team654User: team654
Duration: 1s470msDatabase: team654User: team654
Duration: 1s462msDatabase: team654User: team654

Rank	Count	Total size	Min size	Max size	Avg size	Query
1	70	859.11 MiB	12.27 MiB	12.28 MiB	12.27 MiB	SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( to_char ( date, '' ) LIKE upper ( '' ) ) ORDER BY view_stadium_reports.checkin_date ASC, view_stadium_reports.id ASC LIMIT 0 offset 0; SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( to_char ( date, 'YYYY-MM-DD' ) LIKE upper ( '%number one%' ) ) ORDER BY view_stadium_reports.checkin_date ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; Duration: 1s502ms Database: team654 User: team654 SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( to_char ( date, 'YYYY-MM-DD' ) LIKE upper ( '%number one%' ) ) ORDER BY view_stadium_reports.checkin_date ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; Duration: 1s501ms Database: team654 User: team654 SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( to_char ( date, 'YYYY-MM-DD' ) LIKE upper ( '%number one%' ) ) ORDER BY view_stadium_reports.checkin_date ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; Duration: 1s494ms Database: team654 User: team654
2	37	454.00 MiB	12.27 MiB	12.29 MiB	12.27 MiB	SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( to_char ( date, '' ) LIKE upper ( '' ) ) ORDER BY view_stadium_reports.job_title_name ASC, view_stadium_reports.id ASC LIMIT 0 offset 0; SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( to_char ( date, 'YYYY-MM-DD' ) LIKE upper ( '%number one%' ) ) ORDER BY view_stadium_reports.job_title_name ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 200; Duration: 1s486ms Database: team654 User: team654 SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( to_char ( date, 'YYYY-MM-DD' ) LIKE upper ( '%number one%' ) ) ORDER BY view_stadium_reports.job_title_name ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; Duration: 1s483ms Database: team654 User: team654 SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( to_char ( date, 'YYYY-MM-DD' ) LIKE upper ( '%number one%' ) ) ORDER BY view_stadium_reports.job_title_name ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; Duration: 1s480ms Database: team654 User: team654
3	27	331.23 MiB	12.27 MiB	12.28 MiB	12.27 MiB	SELECT count ( * ) FROM "view_stadium_reports" WHERE ( to_char ( date, '' ) LIKE upper ( '' ) ); SELECT count ( * ) FROM "view_stadium_reports" WHERE ( to_char ( date, 'YYYY-MM-DD' ) LIKE upper ( '%number one%' ) ); Duration: 1s499ms Database: team654 User: team654 SELECT count ( * ) FROM "view_stadium_reports" WHERE ( to_char ( date, 'YYYY-MM-DD' ) LIKE upper ( '%number one%' ) ); Duration: 1s481ms Database: team654 User: team654 SELECT count ( * ) FROM "view_stadium_reports" WHERE ( to_char ( date, 'YYYY-MM-DD' ) LIKE upper ( '%number one%' ) ); Duration: 1s477ms Database: team654 User: team654
4	27	343.77 MiB	12.27 MiB	24.59 MiB	12.73 MiB	SELECT count ( * ) FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.hotel ) AS text ) ) LIKE upper ( '' ) ); SELECT count ( * ) FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.hotel ) AS text ) ) LIKE upper ( '%number one%' ) ); Duration: 1s497ms Database: team654 User: team654 SELECT count ( * ) FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.hotel ) AS text ) ) LIKE upper ( '%number one%' ) ); Duration: 1s490ms Database: team654 User: team654 SELECT count ( * ) FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.hotel ) AS text ) ) LIKE upper ( '%number one%' ) ); Duration: 1s490ms Database: team654 User: team654
5	15	184.09 MiB	12.27 MiB	12.27 MiB	12.27 MiB	SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.hotel ) AS text ) ) LIKE upper ( '' ) ) ORDER BY view_stadium_reports.checkin_date ASC, view_stadium_reports.id ASC LIMIT 0 offset 0; SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.hotel ) AS text ) ) LIKE upper ( '%number one%' ) ) ORDER BY view_stadium_reports.checkin_date ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; Duration: 1s518ms Database: team654 User: team654 SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.hotel ) AS text ) ) LIKE upper ( '%number one%' ) ) ORDER BY view_stadium_reports.checkin_date ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; Duration: 1s490ms Database: team654 User: team654 SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.hotel ) AS text ) ) LIKE upper ( '%number one%' ) ) ORDER BY view_stadium_reports.checkin_date ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; Duration: 1s478ms Database: team654 User: team654
6	11	135.05 MiB	12.27 MiB	12.30 MiB	12.28 MiB	SELECT count ( * ) FROM "view_stadium_reports";
7	7	85.95 MiB	12.27 MiB	12.30 MiB	12.28 MiB	SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.hotel ) AS text ) ) LIKE upper ( '' ) ) ORDER BY view_stadium_reports.middle_name ASC, view_stadium_reports.id ASC LIMIT 0 offset 0; SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.hotel ) AS text ) ) LIKE upper ( '%number one%' ) ) ORDER BY view_stadium_reports.middle_name ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; Duration: 1s698ms Database: team654 User: team654 SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.hotel ) AS text ) ) LIKE upper ( '%number one%' ) ) ORDER BY view_stadium_reports.middle_name ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 200; Duration: 1s501ms Database: team654 User: team654 SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.hotel ) AS text ) ) LIKE upper ( '%number one%' ) ) ORDER BY view_stadium_reports.middle_name ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 400; Duration: 1s497ms Database: team654 User: team654
8	6	73.63 MiB	12.27 MiB	12.27 MiB	12.27 MiB	SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.hotel ) AS text ) ) LIKE upper ( '' ) ) ORDER BY view_stadium_reports.hotel DESC, view_stadium_reports.id ASC LIMIT 0 offset 0; SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.hotel ) AS text ) ) LIKE upper ( '%number one%' ) ) ORDER BY view_stadium_reports.hotel DESC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; Duration: 1s537ms Database: team654 User: team654 SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.hotel ) AS text ) ) LIKE upper ( '%number one%' ) ) ORDER BY view_stadium_reports.hotel DESC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; Duration: 1s517ms Database: team654 User: team654 SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.hotel ) AS text ) ) LIKE upper ( '%number one%' ) ) ORDER BY view_stadium_reports.hotel DESC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; Duration: 1s516ms Database: team654 User: team654
9	4	21.12 MiB	5.28 MiB	5.28 MiB	5.28 MiB	SELECT count ( * ) FROM "view_uniform_records";
10	3	36.84 MiB	12.28 MiB	12.28 MiB	12.28 MiB	SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.first_name ) AS text ) ) LIKE upper ( '' ) ) ORDER BY view_stadium_reports.checkin_date ASC, view_stadium_reports.id ASC LIMIT 0 offset 0; SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.first_name ) AS text ) ) LIKE upper ( '%number one%' ) ) ORDER BY view_stadium_reports.checkin_date ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; Duration: 1s458ms Database: team654 User: team654 SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.first_name ) AS text ) ) LIKE upper ( '%number one%' ) ) ORDER BY view_stadium_reports.checkin_date ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; Duration: 1s455ms Database: team654 User: team654 SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.first_name ) AS text ) ) LIKE upper ( '%number one%' ) ) ORDER BY view_stadium_reports.checkin_date ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; Duration: 1s449ms Database: team654 User: team654
11	3	36.83 MiB	12.27 MiB	12.28 MiB	12.28 MiB	SELECT "view_stadium_reports".* FROM "view_stadium_reports" ORDER BY view_stadium_reports.date ASC, view_stadium_reports.id ASC LIMIT 0 offset 0; SELECT "view_stadium_reports".* FROM "view_stadium_reports" ORDER BY view_stadium_reports.date ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; Duration: 1s417ms Database: team654 User: team654 SELECT "view_stadium_reports".* FROM "view_stadium_reports" ORDER BY view_stadium_reports.date ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; Duration: 1s413ms Database: team654 User: team654 SELECT "view_stadium_reports".* FROM "view_stadium_reports" ORDER BY view_stadium_reports.date ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; Duration: 1s411ms Database: team654 User: team654
12	3	36.83 MiB	12.27 MiB	12.28 MiB	12.28 MiB	SELECT "view_stadium_reports".* FROM "view_stadium_reports" ORDER BY view_stadium_reports.checkin_date ASC, view_stadium_reports.id ASC LIMIT 0 offset 0; SELECT "view_stadium_reports".* FROM "view_stadium_reports" ORDER BY view_stadium_reports.checkin_date ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; Duration: 1s421ms Database: team654 User: team654 SELECT "view_stadium_reports".* FROM "view_stadium_reports" ORDER BY view_stadium_reports.checkin_date ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; Duration: 1s412ms Database: team654 User: team654 SELECT "view_stadium_reports".* FROM "view_stadium_reports" ORDER BY view_stadium_reports.checkin_date ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; Duration: 1s410ms Database: team654 User: team654
13	3	15.84 MiB	5.28 MiB	5.28 MiB	5.28 MiB	SELECT "view_uniform_records".* FROM "view_uniform_records" ORDER BY view_uniform_records.uniform_distribution_date ASC, view_uniform_records.id ASC LIMIT 0 offset 0; SELECT "view_uniform_records".* FROM "view_uniform_records" ORDER BY view_uniform_records.uniform_distribution_date ASC, view_uniform_records.id ASC LIMIT 200 OFFSET 0; Duration: 1s758ms Database: team654 User: team654 SELECT "view_uniform_records".* FROM "view_uniform_records" ORDER BY view_uniform_records.uniform_distribution_date ASC, view_uniform_records.id ASC LIMIT 200 OFFSET 0; Duration: 1s757ms Database: team654 User: team654 SELECT "view_uniform_records".* FROM "view_uniform_records" ORDER BY view_uniform_records.uniform_distribution_date ASC, view_uniform_records.id ASC LIMIT 200 OFFSET 0; Duration: 1s757ms Database: team654 User: team654
14	3	36.84 MiB	12.27 MiB	12.30 MiB	12.28 MiB	SELECT "view_stadium_reports".* FROM "view_stadium_reports" ORDER BY view_stadium_reports.hotel ASC, view_stadium_reports.id ASC LIMIT 0 offset 0; SELECT "view_stadium_reports".* FROM "view_stadium_reports" ORDER BY view_stadium_reports.hotel ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; Duration: 1s448ms Database: team654 User: team654 SELECT "view_stadium_reports".* FROM "view_stadium_reports" ORDER BY view_stadium_reports.hotel ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; Duration: 1s446ms Database: team654 User: team654 SELECT "view_stadium_reports".* FROM "view_stadium_reports" ORDER BY view_stadium_reports.hotel ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; Duration: 1s439ms Database: team654 User: team654
15	2	24.55 MiB	12.27 MiB	12.27 MiB	12.27 MiB	SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.last_name ) AS text ) ) LIKE upper ( '' ) ) ORDER BY view_stadium_reports.date ASC, view_stadium_reports.id ASC LIMIT 0 offset 0; SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.last_name ) AS text ) ) LIKE upper ( '%number one%' ) ) ORDER BY view_stadium_reports.date ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; Duration: 1s467ms Database: team654 User: team654 SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.last_name ) AS text ) ) LIKE upper ( '%number one%' ) ) ORDER BY view_stadium_reports.date ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; Duration: 1s458ms Database: team654 User: team654
16	2	24.59 MiB	12.30 MiB	12.30 MiB	12.30 MiB	SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.hotel ) AS text ) ) LIKE upper ( '' ) ) ORDER BY view_stadium_reports.hotel ASC, view_stadium_reports.id ASC LIMIT 0 offset 0; SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.hotel ) AS text ) ) LIKE upper ( '%number one%' ) ) ORDER BY view_stadium_reports.hotel ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; Duration: 1s523ms Database: team654 User: team654 SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.hotel ) AS text ) ) LIKE upper ( '%number one%' ) ) ORDER BY view_stadium_reports.hotel ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; Duration: 1s501ms Database: team654 User: team654 SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.hotel ) AS text ) ) LIKE upper ( '%number one%' ) ) ORDER BY view_stadium_reports.hotel ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; Duration: 1s495ms Database: team654 User: team654
17	2	24.55 MiB	12.27 MiB	12.28 MiB	12.28 MiB	SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.last_name ) AS text ) ) LIKE upper ( '' ) ) ORDER BY view_stadium_reports.middle_name ASC, view_stadium_reports.id ASC LIMIT 0 offset 0; SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.last_name ) AS text ) ) LIKE upper ( '%number one%' ) ) ORDER BY view_stadium_reports.middle_name ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; Duration: 1s454ms Database: team654 User: team654 SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.last_name ) AS text ) ) LIKE upper ( '%number one%' ) ) ORDER BY view_stadium_reports.middle_name ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; Duration: 1s453ms Database: team654 User: team654
18	1	12.28 MiB	12.28 MiB	12.28 MiB	12.28 MiB	SELECT "view_stadium_reports".* FROM "view_stadium_reports" ORDER BY view_stadium_reports.middle_name ASC, view_stadium_reports.id ASC LIMIT 0 offset 0; SELECT "view_stadium_reports".* FROM "view_stadium_reports" ORDER BY view_stadium_reports.middle_name ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; Duration: 1s435ms Database: team654 User: team654
19	1	12.27 MiB	12.27 MiB	12.27 MiB	12.27 MiB	SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( to_char ( date, '' ) LIKE upper ( '' ) ) ORDER BY view_stadium_reports.checkin_date ASC, view_stadium_reports.id ASC; SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( to_char ( date, 'YYYY-MM-DD' ) LIKE upper ( '%number one%' ) ) ORDER BY view_stadium_reports.checkin_date ASC, view_stadium_reports.id ASC; Duration: 1s461ms Database: team654 User: team654
20	1	12.27 MiB	12.27 MiB	12.27 MiB	12.27 MiB	SELECT count ( * ) FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.mobility_code ) AS text ) ) LIKE upper ( '' ) ); SELECT count ( * ) FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.mobility_code ) AS text ) ) LIKE upper ( '%number one%' ) ); Duration: 1s450ms Database: team654 User: team654
21	1	5.28 MiB	5.28 MiB	5.28 MiB	5.28 MiB	SELECT "view_uniform_records".* FROM "view_uniform_records" ORDER BY view_uniform_records.id ASC, view_uniform_records.id ASC LIMIT 0 offset 0; SELECT "view_uniform_records".* FROM "view_uniform_records" ORDER BY view_uniform_records.id ASC, view_uniform_records.id ASC LIMIT 200 OFFSET 0; Duration: 1s701ms Database: team654 User: team654
22	1	17.05 MiB	17.05 MiB	17.05 MiB	17.05 MiB	SELECT row_number ( ) OVER ( ORDER BY resources.code ) AS id, services.code AS service_code, services.description AS service_description, services.wom AS service_wom, resources.code AS code, resources.name AS name, positions.code AS location_code, resources.name AS resource_name, resources.masterlist_column AS masterlist_column, targets.name AS target_name, resources.mcr_column AS mcr_column, resources.toc_column AS toc_column FROM "resources" LEFT OUTER JOIN resources ON resources.resource_id = resources.id LEFT OUTER JOIN scheduled ON scheduled.positions_resource_id = resources.id LEFT OUTER JOIN positions ON resources.location_id = positions.id LEFT OUTER JOIN services ON services.resource_id = resources.id LEFT OUTER JOIN services ON services.service_id = services.id LEFT OUTER JOIN targets ON scheduled.target_id = targets.id ORDER BY resources.id ASC, resources.id ASC LIMIT 0 offset 0 resources.code AS code, resources.name AS name, positions.code AS location_code, resources.name AS resource_name, resources.masterlist_column AS masterlist_column, targets.name AS target_name, resources.mcr_column AS mcr_column, resources.toc_column AS toc_column FROM "resources" LEFT OUTER JOIN resources ON resources.resource_id = resources.id LEFT OUTER JOIN scheduled ON scheduled.positions_resource_id = resources.id LEFT OUTER JOIN positions ON resources.location_id = positions.id LEFT OUTER JOIN services ON services.resource_id = resources.id LEFT OUTER JOIN services ON services.service_id = services.id LEFT OUTER JOIN targets ON scheduled.target_id = targets.id ORDER BY resources.id ASC, resources.id ASC LIMIT 0 offset 0;
23	1	12.27 MiB	12.27 MiB	12.27 MiB	12.27 MiB	SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.mobility_code ) AS text ) ) LIKE upper ( '' ) ) ORDER BY view_stadium_reports.date ASC, view_stadium_reports.id ASC LIMIT 0 offset 0; SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.mobility_code ) AS text ) ) LIKE upper ( '%number one%' ) ) ORDER BY view_stadium_reports.date ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; Duration: 1s688ms Database: team654 User: team654
24	1	12.27 MiB	12.27 MiB	12.27 MiB	12.27 MiB	SELECT "view_stadium_reports".* FROM "view_stadium_reports" ORDER BY view_stadium_reports.hotel DESC, view_stadium_reports.id ASC LIMIT 0 offset 0; SELECT "view_stadium_reports".* FROM "view_stadium_reports" ORDER BY view_stadium_reports.hotel DESC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; Duration: 1s437ms Database: team654 User: team654
25	1	12.27 MiB	12.27 MiB	12.27 MiB	12.27 MiB	SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.hotel ) AS text ) ) LIKE upper ( '' ) ) ORDER BY view_stadium_reports.id ASC, view_stadium_reports.id ASC LIMIT 0 offset 0; SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.hotel ) AS text ) ) LIKE upper ( '%number one%' ) ) ORDER BY view_stadium_reports.id ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; Duration: 1s470ms Database: team654 User: team654
26	1	12.28 MiB	12.28 MiB	12.28 MiB	12.28 MiB	SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.hotel ) AS text ) ) LIKE upper ( '' ) ) ORDER BY view_stadium_reports.date ASC, view_stadium_reports.id ASC LIMIT 0 offset 0; SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.hotel ) AS text ) ) LIKE upper ( '%number one%' ) ) ORDER BY view_stadium_reports.date ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; Duration: 1s462ms Database: team654 User: team654

Queries generating the largest temporary files


[ Date: 2012-12-07 00:01:36 - Database: team654 - User: team654 ]
[ Date: 2012-12-07 17:56:30 - Database: bss_test - User: bss_test ]
[ Date: 2012-12-07 00:12:55 - Database: team654 - User: team654 ]
[ Date: 2012-12-07 00:12:57 - Database: team654 - User: team654 ]
[ Date: 2012-12-07 00:13:05 - Database: team654 - User: team654 ]
[ Date: 2012-12-07 00:13:06 - Database: team654 - User: team654 ]
[ Date: 2012-12-07 00:13:19 - Database: team654 - User: team654 ]
[ Date: 2012-12-07 00:13:20 - Database: team654 - User: team654 ]
[ Date: 2012-12-07 00:13:42 - Database: team654 - User: team654 ]
[ Date: 2012-12-07 00:13:43 - Database: team654 - User: team654 ]
[ Date: 2012-12-07 01:05:16 - Database: team654 - User: team654 ]
[ Date: 2012-12-07 10:58:14 - Database: team654 - User: team654 ]
[ Date: 2012-12-07 10:58:16 - Database: team654 - User: team654 ]
[ Date: 2012-12-07 10:58:21 - Database: team654 - User: team654 ]
[ Date: 2012-12-07 10:58:23 - Database: team654 - User: team654 ]
[ Date: 2012-12-07 16:43:00 - Database: team654 - User: team654 ]
[ Date: 2012-12-07 16:43:01 - Database: team654 - User: team654 ]
[ Date: 2012-12-07 16:43:02 - Database: team654 - User: team654 ]
[ Date: 2012-12-07 16:43:03 - Database: team654 - User: team654 ]
[ Date: 2012-12-07 16:43:09 - Database: team654 - User: team654 ]

Rank	Size	Query
1	24.59 MiB	SELECT count ( * ) FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.hotel ) AS text ) ) LIKE upper ( '%number one%' ) ); [ Date: 2012-12-07 00:01:36 - Database: team654 - User: team654 ]
2	17.05 MiB	SELECT ROW_NUMBER ( ) OVER ( ORDER BY resources.code ) AS id, services.code AS service_code, services.description AS service_description, services.wom AS service_wom, resources.code AS code, resources.name AS name, positions.code AS location_code, resources.name AS resource_name, resources.masterlist_column AS masterlist_column, targets.name AS target_name, resources.mcr_column AS mcr_column, resources.toc_column AS toc_column FROM "resources" LEFT OUTER JOIN resources ON resources.resource_id = resources.id LEFT OUTER JOIN scheduled ON scheduled.positions_resource_id = resources.id LEFT OUTER JOIN positions ON resources.location_id = positions.id LEFT OUTER JOIN services ON services.resource_id = resources.id LEFT OUTER JOIN services ON services.service_id = services.id LEFT OUTER JOIN targets ON scheduled.target_id = targets.id ORDER BY resources.id ASC, resources.id ASC LIMIT 200 OFFSET 0 resources.code AS code, resources.name AS name, positions.code AS location_code, resources.name AS resource_name, resources.masterlist_column AS masterlist_column, targets.name AS target_name, resources.mcr_column AS mcr_column, resources.toc_column AS toc_column FROM "resources" LEFT OUTER JOIN resources ON resources.resource_id = resources.id LEFT OUTER JOIN scheduled ON scheduled.positions_resource_id = resources.id LEFT OUTER JOIN positions ON resources.location_id = positions.id LEFT OUTER JOIN services ON services.resource_id = resources.id LEFT OUTER JOIN services ON services.service_id = services.id LEFT OUTER JOIN targets ON scheduled.target_id = targets.id ORDER BY resources.id ASC, resources.id ASC LIMIT 200 OFFSET 0; [ Date: 2012-12-07 17:56:30 - Database: bss_test - User: bss_test ]
3	12.30 MiB	SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.hotel ) AS text ) ) LIKE upper ( '%number one%' ) ) ORDER BY view_stadium_reports.hotel ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; [ Date: 2012-12-07 00:12:55 - Database: team654 - User: team654 ]
4	12.30 MiB	SELECT count ( * ) FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.hotel ) AS text ) ) LIKE upper ( '%number one%' ) ); [ Date: 2012-12-07 00:12:57 - Database: team654 - User: team654 ]
5	12.30 MiB	SELECT "view_stadium_reports".* FROM "view_stadium_reports" ORDER BY view_stadium_reports.hotel ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; [ Date: 2012-12-07 00:13:05 - Database: team654 - User: team654 ]
6	12.30 MiB	SELECT count ( * ) FROM "view_stadium_reports"; [ Date: 2012-12-07 00:13:06 - Database: team654 - User: team654 ]
7	12.30 MiB	SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.hotel ) AS text ) ) LIKE upper ( '%number one%' ) ) ORDER BY view_stadium_reports.hotel ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; [ Date: 2012-12-07 00:13:19 - Database: team654 - User: team654 ]
8	12.30 MiB	SELECT count ( * ) FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.hotel ) AS text ) ) LIKE upper ( '%number one%' ) ); [ Date: 2012-12-07 00:13:20 - Database: team654 - User: team654 ]
9	12.30 MiB	SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.hotel ) AS text ) ) LIKE upper ( '%number one%' ) ) ORDER BY view_stadium_reports.middle_name ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; [ Date: 2012-12-07 00:13:42 - Database: team654 - User: team654 ]
10	12.30 MiB	SELECT count ( * ) FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.hotel ) AS text ) ) LIKE upper ( '%number one%' ) ); [ Date: 2012-12-07 00:13:43 - Database: team654 - User: team654 ]
11	12.29 MiB	SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( to_char ( date, 'YYYY-MM-DD' ) LIKE upper ( '%number one%' ) ) ORDER BY view_stadium_reports.job_title_name ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; [ Date: 2012-12-07 01:05:16 - Database: team654 - User: team654 ]
12	12.28 MiB	SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.hotel ) AS text ) ) LIKE upper ( '%number one%' ) ) ORDER BY view_stadium_reports.date ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; [ Date: 2012-12-07 10:58:14 - Database: team654 - User: team654 ]
13	12.28 MiB	SELECT count ( * ) FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.hotel ) AS text ) ) LIKE upper ( '%number one%' ) ); [ Date: 2012-12-07 10:58:16 - Database: team654 - User: team654 ]
14	12.28 MiB	SELECT "view_stadium_reports".* FROM "view_stadium_reports" ORDER BY view_stadium_reports.date ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; [ Date: 2012-12-07 10:58:21 - Database: team654 - User: team654 ]
15	12.28 MiB	SELECT count ( * ) FROM "view_stadium_reports"; [ Date: 2012-12-07 10:58:23 - Database: team654 - User: team654 ]
16	12.28 MiB	SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( to_char ( date, 'YYYY-MM-DD' ) LIKE upper ( '%number one%' ) ) ORDER BY view_stadium_reports.checkin_date ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; [ Date: 2012-12-07 16:43:00 - Database: team654 - User: team654 ]
17	12.28 MiB	SELECT count ( * ) FROM "view_stadium_reports" WHERE ( to_char ( date, 'YYYY-MM-DD' ) LIKE upper ( '%number one%' ) ); [ Date: 2012-12-07 16:43:01 - Database: team654 - User: team654 ]
18	12.28 MiB	SELECT "view_stadium_reports".* FROM "view_stadium_reports" ORDER BY view_stadium_reports.checkin_date ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; [ Date: 2012-12-07 16:43:02 - Database: team654 - User: team654 ]
19	12.28 MiB	SELECT count ( * ) FROM "view_stadium_reports"; [ Date: 2012-12-07 16:43:03 - Database: team654 - User: team654 ]
20	12.28 MiB	SELECT "view_stadium_reports".* FROM "view_stadium_reports" WHERE ( upper ( CAST ( ( view_stadium_reports.first_name ) AS text ) ) LIKE upper ( '%number one%' ) ) ORDER BY view_stadium_reports.checkin_date ASC, view_stadium_reports.id ASC LIMIT 200 OFFSET 0; [ Date: 2012-12-07 16:43:09 - Database: team654 - User: team654 ]

Vacuums / Analyzes Distribution

Key values

18.12 sec Highest CPU-cost vacuum
Table public.gpu
Database nightly
2012-12-07 05:33:26 Date
318.85 sec Highest CPU-cost analyze
Table public.nppsmoketests_2012_12
Database nightly
2012-12-06 05:21:47 Date

Analyses per table

Key values

public.njsmoketests_2012_12 (6) Main table analyzed (database nightly)
149 analyzes Total

Chart
Table

Table	Number of analyzes
nightly.public.njsmoketests_2012_12	6
pvs.public.nppsmoketests_2012_12	6
nightly.public.dblcublastests_2012_12	6
nightly.public.thrusttests_2012_12	6
nightly.public.nppsmoketests_2012_12	6
nightly.public.profsmokenewtests_2012_12	5
nightly.public.dblamodeltests_2012_12	5
nightly.public.nvproftests_2012_12	5
pvs.public.dblcublastests_2012_12	5
pvs.public.thrusttests_2012_12	5
nightly.public.sparse_cublastests_2012_12	5
nightly.public.mathsmokesm2xtests_2012_12	5
pvs.public.cublassmoketests_2012_12	5
pvs.public.njsmoketests_2012_12	5
nightly.public.cufftsmoketests_2012_12	5
pvs.public.cudasmoketests_2012_12	5
nightly.public.cublassmoketests_2012_12	5
nightly.public.mc_dblcublastests_2012_12	5
nightly.public.cudasmoketests_2012_12	5
nightly.public.smoke32on64tests_2012_12	5
nightly.public.curandtests_2012_12	5
nightly.public.mc_cusparsetests_2012_12	4
nightly.public.dblcuffttests_2012_12	4
nightly.public.mc_cublastests_2012_12	4
pvs.public.dblamodeltests_2012_12	4
pvs.public.sparse_cublastests_2012_12	4
pvs.public.cufftsmoketests_2012_12	3
pvs.public.mc_dblcublastests_2012_12	2
cbs.public.systems	2
inventory.public.user_preferences	2
nightly.public.interop32on64tests	1
nightly.public.samplestests_2012_12	1
pvs.public.mc_cublastests_2012_12	1
pvs.public.njdblcublastests_2012_12	1
pvs.public.dblcuffttests_2012_12	1
nightly.public.gpu	1
nightly.public.cupti	1
nightly.public.debuggertests_2012_12	1
nightly.public.nvprof32on64tests_2012_12	1
nightly.public.oclconformance11tests_2012_12	1
Total	149

Vacuums per table

Key values

public.gpu (67) Main table vacuumed on database nightly
79 vacuums Total

Chart
Table

Table	Number of vacuums	Index scans
nightly.public.gpu	67	57
cbs.public.systems	6	3
cbs.pg_catalog.pg_statistic	1	1
nightly.pg_catalog.pg_statistic	1	1
nightly.public.cudasmoke_2012_12	1	1
pvs.pg_catalog.pg_statistic	1	1
inventory.public.user_preferences	1	1
pvs.public.curand_2012_12	1	1
Total	79	66

Tuples removed per table

Key values

public.gpu (33452) Main table with removed tuples on database nightly
43360 tuples Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed
nightly.public.gpu	67	57	33452
inventory.public.user_preferences	1	1	4131
nightly.pg_catalog.pg_statistic	1	1	3567
pvs.pg_catalog.pg_statistic	1	1	1742
cbs.public.systems	6	3	217
cbs.pg_catalog.pg_statistic	1	1	149
nightly.public.cudasmoke_2012_12	1	1	98
pvs.public.curand_2012_12	1	1	4
Total	79	66	43,360

Pages removed per table

Key values

unknown (0) Main table with removed pages on database
0 pages Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed
cbs.public.systems	6	3	217
cbs.pg_catalog.pg_statistic	1	1	149
nightly.pg_catalog.pg_statistic	1	1	3567
nightly.public.cudasmoke_2012_12	1	1	98
nightly.public.gpu	67	57	33452
pvs.pg_catalog.pg_statistic	1	1	1742
inventory.public.user_preferences	1	1	4131
pvs.public.curand_2012_12	1	1	4
Total	79	66	43,360

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Dec 06	00	0	0
	01	0	0
	02	0	0
	03	0	0
	04	0	5
	05	5	15
	06	2	10
	07	0	8
	08	0	2
	09	1	7
	10	12	3
	11	39	3
	12	0	0
	13	0	1
	14	0	0
	15	0	0
	16	0	1
	17	0	0
	18	0	0
	19	0	1
	20	0	0
	21	0	0
	22	0	0
	23	0	0
Dec 07	00	0	0
	01	0	0
	02	1	0
	03	0	0
	04	0	2
	05	3	13
	06	1	7
	07	1	8
	08	3	5
	09	1	4
	10	0	5
	11	0	0
	12	0	3
	13	0	1
	14	0	1
	15	0	0
	16	0	2
	17	0	0
	18	0	0
	19	0	0
	20	0	0
	21	0	0
	22	0	0
	23	0	0
Dec 08	00	0	0
	01	0	0
	02	0	0
	03	0	0
	04	0	0
	05	0	0
	06	0	0
	07	0	0
	08	0	0
	09	0	0
	10	0	0
	11	0	0
	12	0	0
	13	0	0
	14	0	0
	15	0	0
	16	0	0
	17	0	0
	18	0	0
	19	0	0
	20	0	0
	21	0	0
	22	0	0
	23	0	0
Dec 09	00	0	0
	01	0	1
	02	0	0
	03	0	0
	04	0	0
	05	0	0
	06	0	0
	07	0	0
	08	0	0
	09	0	0
	10	0	0
	11	0	0
	12	0	0
	13	0	0
	14	0	0
	15	0	0
	16	0	0
	17	0	0
	18	0	0
	19	0	0
	20	0	0
	21	0	0
	22	0	0
	23	1	0
Dec 10	00	0	0
Dec 11	00	0	0
	01	0	0
	02	0	0
	03	0	0
	04	0	4
	05	2	8
	06	0	6
	07	1	4
	08	0	6
	09	2	1
	10	2	2
	11	0	3
	12	0	1
	13	0	2
	14	0	0
	15	0	0
	16	1	1
	17	0	1
	18	1	0
	19	0	1
	20	0	0
	21	0	0
	22	0	1
	23	0	0
Dec 12	00	0	0

↑ Back to the top of the Temporay Files Activity table

Locks by types

Key values

ExclusiveLock Main Lock Type
15 locks Total

Chart
Table

Type	Object	Count	Total Duration	Average Duration (s)
ExclusiveLock		15	31s382ms	2s92ms
	extension	15	31s382ms	2s92ms
	Total	15	31s382ms	2s92ms

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
1	15	31s382ms	1s45ms	4s564ms	2s92ms	COPY nppsmoketests ( last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion ) FROM STDIN WITH CSV HEADER ESCAPE '';

Rank

Count

Total time

Min time

Max time

Avg duration

Query

1

15

31s382ms

1s45ms

4s564ms

2s92ms

COPY nppsmoketests ( last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion ) FROM STDIN WITH CSV HEADER ESCAPE '';

Queries that waited the most


[ Date: 2012-12-07 05:32:25 - Database: nightly - User: lfriedman ]
[ Date: 2012-12-07 05:33:28 - Database: nightly - User: lfriedman ]
[ Date: 2012-12-06 05:18:21 - Database: nightly - User: lfriedman ]
[ Date: 2012-12-06 05:17:47 - Database: nightly - User: lfriedman ]
[ Date: 2012-12-06 05:17:47 - Database: nightly - User: lfriedman ]
[ Date: 2012-12-06 05:17:50 - Database: nightly - User: lfriedman ]
[ Date: 2012-12-06 05:16:56 - Database: nightly - User: lfriedman ]
[ Date: 2012-12-07 06:17:24 - Database: nightly - User: lfriedman ]
[ Date: 2012-12-07 05:32:06 - Database: nightly - User: lfriedman ]
[ Date: 2012-12-06 05:17:52 - Database: nightly - User: lfriedman ]
[ Date: 2012-12-07 05:31:20 - Database: nightly - User: lfriedman ]
[ Date: 2012-12-07 05:31:49 - Database: nightly - User: lfriedman ]
[ Date: 2012-12-07 07:52:33 - Database: nightly - User: lfriedman ]
[ Date: 2012-12-06 05:16:57 - Database: nightly - User: lfriedman ]
[ Date: 2012-12-06 05:16:57 - Database: nightly - User: lfriedman ]

Rank	Wait time	Query
1	4s564ms	COPY nppsmoketests ( last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion ) FROM STDIN WITH CSV HEADER ESCAPE '~'; [ Date: 2012-12-07 05:32:25 - Database: nightly - User: lfriedman ]
2	3s213ms	COPY nppsmoketests ( last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion ) FROM STDIN WITH CSV HEADER ESCAPE '~'; [ Date: 2012-12-07 05:33:28 - Database: nightly - User: lfriedman ]
3	3s160ms	COPY nppsmoketests ( last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion ) FROM STDIN WITH CSV HEADER ESCAPE '~'; [ Date: 2012-12-06 05:18:21 - Database: nightly - User: lfriedman ]
4	2s476ms	COPY nppsmoketests ( last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion ) FROM STDIN WITH CSV HEADER ESCAPE '~'; [ Date: 2012-12-06 05:17:47 - Database: nightly - User: lfriedman ]
5	2s464ms	COPY nppsmoketests ( last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion ) FROM STDIN WITH CSV HEADER ESCAPE '~'; [ Date: 2012-12-06 05:17:47 - Database: nightly - User: lfriedman ]
6	2s441ms	COPY nppsmoketests ( last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion ) FROM STDIN WITH CSV HEADER ESCAPE '~'; [ Date: 2012-12-06 05:17:50 - Database: nightly - User: lfriedman ]
7	1s929ms	COPY nppsmoketests ( last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion ) FROM STDIN WITH CSV HEADER ESCAPE '~'; [ Date: 2012-12-06 05:16:56 - Database: nightly - User: lfriedman ]
8	1s912ms	COPY nppsmoketests ( last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion ) FROM STDIN WITH CSV HEADER ESCAPE '~'; [ Date: 2012-12-07 06:17:24 - Database: nightly - User: lfriedman ]
9	1s681ms	COPY nppsmoketests ( last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion ) FROM STDIN WITH CSV HEADER ESCAPE '~'; [ Date: 2012-12-07 05:32:06 - Database: nightly - User: lfriedman ]
10	1s486ms	COPY nppsmoketests ( last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion ) FROM STDIN WITH CSV HEADER ESCAPE '~'; [ Date: 2012-12-06 05:17:52 - Database: nightly - User: lfriedman ]
11	1s460ms	COPY nppsmoketests ( last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion ) FROM STDIN WITH CSV HEADER ESCAPE '~'; [ Date: 2012-12-07 05:31:20 - Database: nightly - User: lfriedman ]
12	1s284ms	COPY nppsmoketests ( last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion ) FROM STDIN WITH CSV HEADER ESCAPE '~'; [ Date: 2012-12-07 05:31:49 - Database: nightly - User: lfriedman ]
13	1s210ms	COPY nppsmoketests ( last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion ) FROM STDIN WITH CSV HEADER ESCAPE '~'; [ Date: 2012-12-07 07:52:33 - Database: nightly - User: lfriedman ]
14	1s50ms	COPY nppsmoketests ( last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion ) FROM STDIN WITH CSV HEADER ESCAPE '~'; [ Date: 2012-12-06 05:16:57 - Database: nightly - User: lfriedman ]
15	1s45ms	COPY nppsmoketests ( last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion ) FROM STDIN WITH CSV HEADER ESCAPE '~'; [ Date: 2012-12-06 05:16:57 - Database: nightly - User: lfriedman ]

Queries by type

Key values

17,187 Total read queries
27,767 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	17,187	0.03%
INSERT	3,878	0.01%
UPDATE	19,552	0.03%
DELETE	400	0.00%
COPY FROM	968	0.00%
COPY TO	1	0.00%
CTE	0	0.00%
DDL	2,964	0.00%
TCL	4	0.00%
OTHERS	60,322,983	99.93%

Queries by database

Key values

nightly Main database
47,131,907 Requests
7d14h22m55s (nightly)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
bss_fwc14	Total	1	1s701ms
	COPY TO	1	1s701ms
bss_test	Total	1	1s171ms
	SELECT	1	1s171ms
cbs	Total	1,448,733	2h10m58s
	DELETE	1	517ms
	INSERT	1	607ms
	SELECT	483	9m34s
	UPDATE	3,411	53m12s
inventory	Total	10,983,910	1h45m33s
	COPY FROM	15	11s144ms
	DELETE	228	3m32s
	INSERT	20	17s804ms
	SELECT	161	2m52s
	UPDATE	308	3m59s
mbm	Total	413,670	10m40s
	SELECT	19	12s795ms
	UPDATE	6	4s554ms
nightly	Total	47,131,907	7d14h22m55s
	COPY FROM	779	3h18m52s
	DDL	2,964	0ms
	DELETE	156	4m49s
	INSERT	3,803	53m23s
	SELECT	15,350	5h21m30s
	TCL	4	3s465ms
	UPDATE	15,729	3h47m34s
postgres	Total	2,077	4s341ms
	SELECT	1	330ms
pvs	Total	386,668	2h8m23s
	COPY FROM	174	35m25s
	DELETE	15	9s200ms
	INSERT	54	48s233ms
	SELECT	202	7m5s
	UPDATE	98	1m46s
team654	Total	970	45m53s
	SELECT	970	45m53s

Queries by user

Key values

lfriedman Main user
60,364,888 Requests

Queries Chart
Table

User	Request type	Count	Duration
bss_fwc14	Total	1	1s701ms
	COPY TO	1	1s701ms
bss_test	Total	1	1s171ms
	SELECT	1	1s171ms
lfriedman	Total	60,364,888	7d20h38m31s
	COPY FROM	968	3h54m29s
	DDL	2,964	0ms
	DELETE	400	8m32s
	INSERT	3,878	54m30s
	SELECT	16,215	5h41m15s
	TCL	4	3s465ms
	UPDATE	19,552	4h46m38s
postgres	Total	2,077	4s341ms
	SELECT	1	330ms
team654	Total	970	45m53s
	SELECT	970	45m53s

Duration by user

Key values

7d20h38m31s (lfriedman) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
bss_fwc14	Total	1	1s701ms
	COPY TO	1	1s701ms
bss_test	Total	1	1s171ms
	SELECT	1	1s171ms
lfriedman	Total	60,364,888	7d20h38m31s
	COPY FROM	968	3h54m29s
	DDL	2,964	0ms
	DELETE	400	8m32s
	INSERT	3,878	54m30s
	SELECT	16,215	5h41m15s
	TCL	4	3s465ms
	UPDATE	19,552	4h46m38s
postgres	Total	2,077	4s341ms
	SELECT	1	330ms
team654	Total	970	45m53s
	SELECT	970	45m53s

Queries by host

Key values

unknown Main host
60,367,937 Requests
7d21h24m32s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	60,367,937	7d21h24m32s
	COPY FROM	968	3h54m29s
	COPY TO	1	1s701ms
	DDL	2,964	0ms
	DELETE	400	8m32s
	INSERT	3,878	54m30s
	SELECT	17,187	6h27m10s
	TCL	4	3s465ms
	UPDATE	19,552	4h46m38s

Queries by application

Key values

unknown Main application
60,367,937 Requests
7d21h24m32s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	60,367,937	7d21h24m32s
	COPY FROM	968	3h54m29s
	COPY TO	1	1s701ms
	DDL	2,964	0ms
	DELETE	400	8m32s
	INSERT	3,878	54m30s
	SELECT	17,187	6h27m10s
	TCL	4	3s465ms
	UPDATE	19,552	4h46m38s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2012-12-11 12:43:12 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Top Queries

Histogram of query times

Key values

36,466,367 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	36,466,367	60.41%
1-5ms	2,658,520	4.40%
5-10ms	1,169,904	1.94%
10-25ms	7,754,359	12.85%
25-50ms	11,525,083	19.09%
50-100ms	542,568	0.90%
100-500ms	221,969	0.37%
500-1000ms	16,370	0.03%
1000-10000ms	9,452	0.02%
> 10000ms	381	0.00%

Slowest individual queries


[ Date: 2012-12-06 05:20:11 - Database: nightly - User: lfriedman ]
[ Date: 2012-12-06 05:20:19 - Database: nightly - User: lfriedman ]
[ Date: 2012-12-06 05:20:21 - Database: nightly - User: lfriedman ]
[ Date: 2012-12-07 06:20:48 - Database: nightly - User: lfriedman ]
[ Date: 2012-12-07 06:20:53 - Database: nightly - User: lfriedman ]
[ Date: 2012-12-07 06:20:10 - Database: nightly - User: lfriedman ]
[ Date: 2012-12-07 05:33:45 - Database: nightly - User: lfriedman ]
[ Date: 2012-12-07 06:21:04 - Database: nightly - User: lfriedman ]
[ Date: 2012-12-07 05:34:02 - Database: nightly - User: lfriedman ]
[ Date: 2012-12-11 07:21:40 - Database: nightly - User: lfriedman ]
[ Date: 2012-12-07 07:38:14 - Database: nightly - User: lfriedman ]
[ Date: 2012-12-11 05:51:12 - Database: nightly - User: lfriedman ]
[ Date: 2012-12-07 06:17:29 - Database: nightly - User: lfriedman ]
[ Date: 2012-12-11 06:29:12 - Database: pvs - User: lfriedman ]
[ Date: 2012-12-11 07:26:46 - Database: nightly - User: lfriedman ]
[ Date: 2012-12-11 07:20:23 - Database: nightly - User: lfriedman ]
[ Date: 2012-12-07 05:03:25 - Database: nightly - User: lfriedman ]
[ Date: 2012-12-07 07:52:51 - Database: nightly - User: lfriedman ]
[ Date: 2012-12-11 07:27:16 - Database: nightly - User: lfriedman ]
[ Date: 2012-12-07 08:37:24 - Database: nightly - User: lfriedman ]

Rank	Duration	Query
1	4m28s	COPY nppsmoketests ( last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion ) FROM STDIN WITH CSV HEADER ESCAPE '~'; [ Date: 2012-12-06 05:20:11 - Database: nightly - User: lfriedman ]
2	4m22s	COPY nppsmoketests ( last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion ) FROM STDIN WITH CSV HEADER ESCAPE '~'; [ Date: 2012-12-06 05:20:19 - Database: nightly - User: lfriedman ]
3	4m19s	COPY nppsmoketests ( last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion ) FROM STDIN WITH CSV HEADER ESCAPE '~'; [ Date: 2012-12-06 05:20:21 - Database: nightly - User: lfriedman ]
4	4m6s	COPY nppsmoketests ( last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion ) FROM STDIN WITH CSV HEADER ESCAPE '~'; [ Date: 2012-12-07 06:20:48 - Database: nightly - User: lfriedman ]
5	4m5s	COPY nppsmoketests ( last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion ) FROM STDIN WITH CSV HEADER ESCAPE '~'; [ Date: 2012-12-07 06:20:53 - Database: nightly - User: lfriedman ]
6	4m5s	COPY nppsmoketests ( last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion ) FROM STDIN WITH CSV HEADER ESCAPE '~'; [ Date: 2012-12-07 06:20:10 - Database: nightly - User: lfriedman ]
7	3m46s	COPY nppsmoketests ( last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion ) FROM STDIN WITH CSV HEADER ESCAPE '~'; [ Date: 2012-12-07 05:33:45 - Database: nightly - User: lfriedman ]
8	3m40s	COPY nppsmoketests ( last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion ) FROM STDIN WITH CSV HEADER ESCAPE '~'; [ Date: 2012-12-07 06:21:04 - Database: nightly - User: lfriedman ]
9	3m36s	COPY nppsmoketests ( last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion ) FROM STDIN WITH CSV HEADER ESCAPE '~'; [ Date: 2012-12-07 05:34:02 - Database: nightly - User: lfriedman ]
10	3m8s	COPY nppsmoketests ( last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion ) FROM STDIN WITH CSV HEADER ESCAPE '~'; [ Date: 2012-12-11 07:21:40 - Database: nightly - User: lfriedman ]
11	2m38s	COPY nppsmoketests ( last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion ) FROM STDIN WITH CSV HEADER ESCAPE '~'; [ Date: 2012-12-07 07:38:14 - Database: nightly - User: lfriedman ]
12	2m37s	COPY nppsmoketests ( last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion ) FROM STDIN WITH CSV HEADER ESCAPE '~'; [ Date: 2012-12-11 05:51:12 - Database: nightly - User: lfriedman ]
13	2m36s	COPY nppsmoketests ( last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion ) FROM STDIN WITH CSV HEADER ESCAPE '~'; [ Date: 2012-12-07 06:17:29 - Database: nightly - User: lfriedman ]
14	2m30s	COPY nppsmoketests ( last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion ) FROM STDIN WITH CSV HEADER ESCAPE '~'; [ Date: 2012-12-11 06:29:12 - Database: pvs - User: lfriedman ]
15	2m25s	COPY nppsmoketests ( last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion ) FROM STDIN WITH CSV HEADER ESCAPE '~'; [ Date: 2012-12-11 07:26:46 - Database: nightly - User: lfriedman ]
16	2m23s	COPY nppsmoketests ( last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion ) FROM STDIN WITH CSV HEADER ESCAPE '~'; [ Date: 2012-12-11 07:20:23 - Database: nightly - User: lfriedman ]
17	2m23s	COPY nppsmoketests ( last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion ) FROM STDIN WITH CSV HEADER ESCAPE '~'; [ Date: 2012-12-07 05:03:25 - Database: nightly - User: lfriedman ]
18	2m19s	COPY nppsmoketests ( last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion ) FROM STDIN WITH CSV HEADER ESCAPE '~'; [ Date: 2012-12-07 07:52:51 - Database: nightly - User: lfriedman ]
19	2m16s	COPY nppsmoketests ( last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion ) FROM STDIN WITH CSV HEADER ESCAPE '~'; [ Date: 2012-12-11 07:27:16 - Database: nightly - User: lfriedman ]
20	2m11s	COPY nppsmoketests ( last_update, testname, current_status, suiteid, regressioncl, testcl, os, arch, build_type, branch, gpu, subtest, osversion ) FROM STDIN WITH CSV HEADER ESCAPE '~'; [ Date: 2012-12-07 08:37:24 - Database: nightly - User: lfriedman ]

Time consuming queries


[User: lfriedman - Total duration: 4h9m39s - Times executed: 11135 ]
[User: lfriedman - Total duration: 3h42m17s - Times executed: 132 ]
[User: lfriedman - Total duration: 1h40m37s - Times executed: 6895 ]
[User: lfriedman - Total duration: 53m8s - Times executed: 3406 ]
[User: lfriedman - Total duration: 43m5s - Times executed: 2986 ]
[User: lfriedman - Total duration: 39m22s - Times executed: 2816 ]
[User: lfriedman - Total duration: 31m43s - Times executed: 2022 ]
[User: lfriedman - Total duration: 18m33s - Times executed: 1515 ]
[User: lfriedman - Total duration: 16m2s - Times executed: 1319 ]
[User: lfriedman - Total duration: 11m49s - Times executed: 881 ]
[User: lfriedman - Total duration: 11m11s - Times executed: 1673 ]
[User: lfriedman - Total duration: 10m7s - Times executed: 734 ]
[User: lfriedman - Total duration: 8m55s - Times executed: 361 ]
[User: lfriedman - Total duration: 6m49s - Times executed: 463 ]
[User: team654 - Total duration: 5m46s - Times executed: 76 ]
[User: lfriedman - Total duration: 5m44s - Times executed: 340 ]
[User: lfriedman - Total duration: 3m30s - Times executed: 38 ]
[User: team654 - Total duration: 3m24s - Times executed: 45 ]
[User: lfriedman - Total duration: 3m11s - Times executed: 268 ]
[User: lfriedman - Total duration: 3m3s - Times executed: 5 ]

Most frequent queries (N)


[User: lfriedman - Total duration: 4h9m39s - Times executed: 11135 ]
[User: lfriedman - Total duration: 1h40m37s - Times executed: 6895 ]
[User: lfriedman - Total duration: 53m8s - Times executed: 3406 ]
[User: lfriedman - Total duration: 43m5s - Times executed: 2986 ]
[User: lfriedman - Total duration: 39m22s - Times executed: 2816 ]
[User: lfriedman - Total duration: 31m43s - Times executed: 2022 ]
[User: lfriedman - Total duration: 11m11s - Times executed: 1673 ]
[User: lfriedman - Total duration: 18m33s - Times executed: 1515 ]
[User: lfriedman - Total duration: 16m2s - Times executed: 1319 ]
[User: lfriedman - Total duration: 11m49s - Times executed: 881 ]
[User: lfriedman - Total duration: 10m7s - Times executed: 734 ]
[User: lfriedman - Total duration: 6m49s - Times executed: 463 ]
[User: lfriedman - Total duration: 8m55s - Times executed: 361 ]
[User: lfriedman - Total duration: 5m44s - Times executed: 340 ]
[User: lfriedman - Total duration: 3m11s - Times executed: 268 ]
[User: lfriedman - Total duration: 2m59s - Times executed: 201 ]
[User: lfriedman - Total duration: 1m51s - Times executed: 161 ]
[User: lfriedman - Total duration: 1m31s - Times executed: 148 ]
[User: lfriedman - Total duration: 1m51s - Times executed: 145 ]
[User: lfriedman - Total duration: 1m44s - Times executed: 134 ]

Normalized slowest queries (N)


[User: lfriedman - Total duration: 3h42m17s - Times executed: 132 ]
[User: lfriedman - Total duration: 3m3s - Times executed: 5 ]
[User: lfriedman - Total duration: 3m30s - Times executed: 38 ]
[User: team654 - Total duration: 5m46s - Times executed: 76 ]
[User: team654 - Total duration: 3m24s - Times executed: 45 ]
[User: lfriedman - Total duration: 8m55s - Times executed: 361 ]
[User: lfriedman - Total duration: 4h9m39s - Times executed: 11135 ]
[User: lfriedman - Total duration: 5m44s - Times executed: 340 ]
[User: lfriedman - Total duration: 31m43s - Times executed: 2022 ]
[User: lfriedman - Total duration: 53m8s - Times executed: 3406 ]
[User: lfriedman - Total duration: 2m59s - Times executed: 201 ]
[User: lfriedman - Total duration: 6m49s - Times executed: 463 ]
[User: lfriedman - Total duration: 1h40m37s - Times executed: 6895 ]
[User: lfriedman - Total duration: 43m5s - Times executed: 2986 ]
[User: lfriedman - Total duration: 39m22s - Times executed: 2816 ]
[User: lfriedman - Total duration: 10m7s - Times executed: 734 ]
[User: lfriedman - Total duration: 11m49s - Times executed: 881 ]
[User: lfriedman - Total duration: 1m44s - Times executed: 134 ]
[User: lfriedman - Total duration: 1m51s - Times executed: 145 ]
[User: lfriedman - Total duration: 18m33s - Times executed: 1515 ]

Request Throughput

Key values

3,530 queries/s Request Peak
2012-12-09 20:41:21 Date

Bytes I/O Throughput

Key values

5,150,593 Bytes/s In Bytes Peak
2012-12-06 07:16:19 Date
1,061,373 Bytes/s Out Bytes Peak
2012-12-09 00:01:20 Date

Queries Average duration

Key values

113ms Average Duration Peak
2012-12-07 07:10:19 Date

Established Connections

Key values

224 connections Connection Peak
2012-12-09 19:30:34 Date

Connections per database

Key values

nightly Main Database
6,911,942 connections Total

Chart
Table

Database	User	Count
albatros_dimp_test		35
	lfriedman	35
gasworks2		2,876
	lfriedman	2,876
grinderman		16,170
	lfriedman	16,170
intranet		493,660
	lfriedman	493,660
intranet_test		8,211
	lfriedman	8,211
jdb		1,995
	lfriedman	1,995
lfriedman_test		3,288
	lfriedman	3,288
nightly		5,563,060
	lfriedman	5,563,060
optique_production		1,662
	lfriedman	1,662
pgbouncer		3,284
	darold	3,284
sterne_production		3,705
	lfriedman	3,705
vangard_prod		28,430
	lfriedman	28,430
webmail		785,566
	lfriedman	785,566

Connections per user

Key values

lfriedman Main User
6,911,942 connections Total

Chart
Table

User	Count
darold	3,284
lfriedman	6,908,658

Connections per host

Key values

10.10.10.13 Main host with 5127545 connections
6,911,942 Total connections

Chart
Table

Host	Count
10.10.10.22	1,780,917
10.10.10.13	5,127,545
127.0.0.1	3,284
192.168.3.178	187
192.168.3.58	9

Simultaneous sessions

Key values

548 sessions Session Peak
2012-12-09 20:41:26 Date

Histogram of session times

Key values

6,088,590 0-500ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	6,088,590	87.71%
500ms-1s	0	0.00%
1s-30s	790,568	11.39%
30s-1m	29,767	0.43%
1m-10m	28,116	0.41%
10m-30m	4,392	0.06%
30m-1h	399	0.01%
1h-8h	137	0.00%
> 8h	10	0.00%

Sessions per database

Key values

nightly Main Database
6,941,979 sessions Total

Chart
Table

Database	User	Count	Total Duration
albatros_dimp_test	43	10m44s	14s976ms
gasworks2	4,154	1d4h35m31s	24s778ms
grinderman	16,170	1h20m	296ms
intranet	498,477	21d10h29m23s	3s715ms
intranet_test	8,210	4d31m8s	42s322ms
jdb	3,200	1d1h38m50s	28s853ms
lfriedman_test	3,288	3s	0ms
nightly	5,576,882	159d12h3m24s	2s471ms
optique_production	1,821	2h47m28s	5s517ms
pgbouncer	3,284	0ms	0ms
sterne_production	6,042	2d1h18m6s	29s375ms
vangard_prod	29,872	12d2h20m39s	34s990ms
webmail	790,536	22d18h46m34s	2s489ms

Sessions per user

Key values

lfriedman Main User
6,941,979 sessions Total

Chart
Table

User	Count	Total Duration	Average Duration
darold	3,284	0ms
lfriedman	6,938,695	224d8h1m50s

Sessions per host

Key values

10.10.10.13 Main Host
6,941,979 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
10.10.10.22	1,780,917	5d5h3m35s	252ms
10.10.10.13	5,127,548	83d10h44m21s	1s406ms
127.0.0.1	20,856	77d12h33m46s	5m21s
192.168.3.178	187	1m6s	352ms
192.168.3.58	9	8s	888ms
::1:5432	12,462	58d3h38m54s	6m43s

Most used reserved pools

Key values

lfriedman@nightly Most used reserved pool
8,158 Time used
8,222 Total time reserved pools was used

Rank

Times used

Reserved pool

1

8,158

Details

lfriedman@nightly

Times Reported Most used reserved pools #1

Day	Hour	Count
Dec 06	07	30
	08	30
	09	30
	10	30
	11	30
	12	30
	13	30
	14	30
	15	30
	16	30
	17	28
	18	30
	19	30
	20	30
	21	30
	22	30
	23	30
Dec 07	00	30
	01	30
	02	30
	03	30
	04	30
	05	32
	06	55
	07	74
	08	75
	09	84
	10	60
	11	50
	12	26
	13	27
	14	35
	15	60
	16	64
	17	78
	18	84
	19	75
	20	76
	21	82
	22	76
	23	59
Dec 08	00	55
	01	36
	02	34
	03	41
	04	44
	05	62
	06	72
	07	75
	08	80
	09	76
	10	79
	11	61
	12	40
	13	27
	14	40
	15	58
	16	78
	17	68
	18	76
	19	85
	20	85
	21	83
	22	73
	23	79
Dec 09	00	56
	01	53
	02	55
	03	48
	04	51
	05	63
	06	83
	07	81
	08	75
	09	79
	10	70
	11	48
	12	45
	13	32
	14	41
	15	66
	16	86
	17	78
	18	68
	19	67
	20	77
	21	85
	22	81
	23	73
Dec 10	00	63
	01	45
	02	41
	03	57
	04	59
	05	63
	06	83
	07	82
	08	69
	09	83
	10	80
	11	59
	12	56
	13	46
	14	50
	15	73
	16	69
	17	82
	18	86
	19	86
	20	84
	21	84
	22	77
	23	79
Dec 11	00	64
	01	54
	02	57
	03	42
	04	47
	05	75
	06	76
	07	80
	08	77
	09	83
	10	78
	11	60
	12	49
	13	32
	14	45
	15	55
	16	72
	17	81
	18	87
	19	84
	20	85
	21	84
	22	70
	23	67

2

36

Details

lfriedman@webmail

Times Reported Most used reserved pools #2

Day	Hour	Count
Dec 07	10	7
Dec 08	10	9
	13	10
Dec 10	10	10

3

28

Details

lfriedman@intranet

Times Reported Most used reserved pools #3

Day	Hour	Count
Dec 07	08	5
	09	2
	10	1
	15	3
Dec 08	08	1
	11	2
Dec 09	07	1
	08	1
Dec 10	08	4
	10	1
Dec 11	08	2
	09	5

Most Frequent Errors/Events

Key values

8,222 Max number of times the same event was reported
8,252 Total events found

Rank

Times reported

Error

1

8,222

Details

WARNING:  Taking connection from reserve_pool

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Dec 06	07	30
	08	30
	09	30
	10	30
	11	30
	12	30
	13	30
	14	30
	15	30
	16	30
	17	28
	18	30
	19	30
	20	30
	21	30
	22	30
	23	30
Dec 07	00	30
	01	30
	02	30
	03	30
	04	30
	05	32
	06	55
	07	74
	08	80
	09	86
	10	68
	11	50
	12	26
	13	27
	14	35
	15	63
	16	64
	17	78
	18	84
	19	75
	20	76
	21	82
	22	76
	23	59
Dec 08	00	55
	01	36
	02	34
	03	41
	04	44
	05	62
	06	72
	07	75
	08	81
	09	76
	10	88
	11	63
	12	40
	13	37
	14	40
	15	58
	16	78
	17	68
	18	76
	19	85
	20	85
	21	83
	22	73
	23	79
Dec 09	00	56
	01	53
	02	55
	03	48
	04	51
	05	63
	06	83
	07	82
	08	76
	09	79
	10	70
	11	48
	12	45
	13	32
	14	41
	15	66
	16	86
	17	78
	18	68
	19	67
	20	77
	21	85
	22	81
	23	73
Dec 10	00	63
	01	45
	02	41
	03	57
	04	59
	05	63
	06	83
	07	82
	08	73
	09	83
	10	91
	11	59
	12	56
	13	46
	14	50
	15	73
	16	69
	17	82
	18	86
	19	86
	20	84
	21	84
	22	77
	23	79
Dec 11	00	64
	01	54
	02	57
	03	42
	04	47
	05	75
	06	76
	07	80
	08	79
	09	88
	10	78
	11	60
	12	49
	13	32
	14	45
	15	55
	16	72
	17	81
	18	87
	19	84
	20	85
	21	84
	22	70
	23	67

WARNING: Taking connection from reserve_pool
WARNING: Taking connection from reserve_pool
WARNING: Taking connection from reserve_pool

2

30

Details

WARNING:  dropping database '...' as it does not exist anymore or inactive auto-database

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Dec 06	07	2
	11	2
	14	2
	15	2
	16	2
Dec 07	00	2
	01	2
	02	2
	15	1
Dec 08	01	2
	16	1
Dec 09	01	2
	23	2
Dec 10	01	2
Dec 11	01	2
	03	2

WARNING: dropping database 'gasworks2' as it does not exist anymore or inactive auto-database
WARNING: dropping database 'jdb' as it does not exist anymore or inactive auto-database
WARNING: dropping database 'gasworks2' as it does not exist anymore or inactive auto-database

Log levels

Key values

92,865,148 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	30	0.00%
DETAIL	470	0.00%
ERROR	3,948	0.00%
LOG	92,856,485	99.99%
STATEMENT	4,213	0.00%
WARNING	2	0.00%

Events distribution

Key values

0 PANIC entries
0 FATAL entries
3948 ERROR entries
2 WARNING entries

Most Frequent Errors/Events

Key values

3,930 Max number of times the same event was reported
3,950 Total events found


ERROR:  invalid input syntax for type date: "..."
ERROR:  syntax error at or near "..."
ERROR:  column "..." does not exist
ERROR:  invalid input syntax for integer: "..."
WARNING:  pgstat wait timeout
ERROR:  relation "..." does not exist

Overview

Global Stats

SQL Traffic

Key values

SELECT Traffic

Key values

INSERT/UPDATE/DELETE Traffic

Key values

Queries duration

Key values

Prepared queries ratio

Key values

General Activity

Connections

Established Connections

Key values

Connections per database

Key values

Connections per user

Key values

Connections per host

Key values

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per user

Key values

Sessions per host

Key values

Sessions per application

Key values

Checkpoints / Restartpoints

Checkpoints Buffers

Key values

Checkpoints Wal files

Key values

Checkpoints Activity

Temporary Files

Size of temporary files

Key values

Number of temporary files

Key values

Temporary Files Activity

Queries generating the most temporary files (N)

Queries generating the largest temporary files

Vacuums

Vacuums / Analyzes Distribution

Key values

Analyses per table

Key values

Vacuums per table

Key values

Tuples removed per table

Key values

Pages removed per table

Key values

Autovacuum Activity

Locks

Locks by types

Key values

Most frequent waiting queries (N)

Queries that waited the most

Queries

Queries by type

Key values

Queries by database

Key values

Queries by user

Key values

Duration by user

Key values

Queries by host

Key values

Queries by application

Key values

Number of cancelled queries