pgFouine: PostgreSQL log analysis report

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

Generated on 2012-04-19 18:00
Parsed /var/log/pgsql (98,007 lines) in 47s
Log from 2012-04-18 22:14:04 to 2012-04-19 18:00:36

Overall statistics ^

Number of unique normalized queries: 133
Number of queries: 93,461
Total query duration: 47m49s
First query: 2012-04-18 22:14:04
Last query: 2012-04-19 18:00:36
Query peak: 621 queries/s at 2012-04-19 17:14:54

Queries by type ^

Type	Count	Percentage
SELECT	79,914	85.5
INSERT	165	0.2
UPDATE	26	0.0
DELETE	5	0.0

Queries that took up the most time (N) ^

Rank

Total duration

Times executed

Av. duration (s)

Query

21m14s

212.39

SELECT "words"."id", "words"."word", "words"."language", "words"."length", "words"."part_of_speech", "words"."definition", "words"."name" FROM "words" WHERE ("words"."length" = 0 AND "words"."language" = '' AND UPPER("words"."word"::text) LIKE UPPER('') ) ORDER BY "words"."word" ASC LIMIT 0;

11m43s

708

Day	Time	Count	Av. Duration
Apr 18	10pm	64	0.47
	11pm	44	0.40
Apr 19	12am	32	15.62
	1am	36	1.48
	2am	24	0.10
	3am	28	0.04
	4am	8	0.04
	5am	16	0.04
	6am	72	0.04
	7am	72	0.13
	8am	24	0.05
	9am	4	0.06
	10am	48	0.08
	12pm	48	0.09
	1pm	20	0.07
	4pm	8	0.54
	5pm	160	0.44

0.99

1m52s

1,372

Day	Time	Count	Av. Duration
Apr 18	10pm	70	0.01
	11pm	25	0.38
Apr 19	12am	88	1.09
	1am	20	0.03
	2am	76	0.01
	3am	27	0.01
	4am	88	0.00
	5am	43	0.01
	6am	83	0.00
	7am	38	0.00
	8am	98	0.00
	9am	25	0.00
	10am	117	0.00
	11am	32	0.01
	12pm	117	0.01
	1pm	67	0.00
	2pm	120	0.00
	3pm	76	0.00
	4pm	129	0.00
	5pm	32	0.00
	6pm	1	0.00

0.08

SELECT "plog_blogitem"."id", "plog_blogitem"."oid", "plog_blogitem"."title", "plog_blogitem"."alias", "plog_blogitem"."bookmark", "plog_blogitem"."text", "plog_blogitem"."text_rendered", "plog_blogitem"."summary", "plog_blogitem"."url", "plog_blogitem"."pub_date", "plog_blogitem"."display_format", "plog_blogitem"."keywords", "plog_blogitem"."plogrank", "plog_blogitem"."codesyntax", "plog_blogitem"."disallow_comments", "plog_blogitem"."hide_comments", "plog_blogitem"."modify_date" FROM "plog_blogitem" WHERE "plog_blogitem"."id" IN (...);

1m27s

2,521

Day	Time	Count	Av. Duration
Apr 18	10pm	104	0.13
	11pm	68	0.17
Apr 19	12am	171	0.32
	1am	55	0.04
	2am	102	0.00
	3am	60	0.00
	4am	143	0.00
	5am	103	0.00
	6am	121	0.01
	7am	93	0.00
	8am	152	0.00
	9am	60	0.01
	10am	208	0.00
	11am	70	0.01
	12pm	176	0.01
	1pm	148	0.00
	2pm	191	0.00
	3pm	196	0.00
	4pm	206	0.00
	5pm	93	0.00
	6pm	1	0.00

0.03

1m2s

Day	Time	Count	Av. Duration
Apr 18	11pm	9	3.78
Apr 19	12am	2	8.60
	1am	1	0.33
	3am	1	0.56
	5am	3	0.23
	7am	3	0.11
	8am	2	0.20
	9am	5	0.28
	11am	17	0.37
	12pm	3	0.24

1.35

SELECT "words"."id", "words"."word", "words"."language", "words"."length", "words"."part_of_speech", "words"."definition", "words"."name" FROM "words" WHERE ("words"."length" = 0 AND UPPER("words"."word"::text) LIKE UPPER('') AND "words"."language" = '' AND UPPER("words"."word"::text) LIKE UPPER('') ) ORDER BY "words"."word" ASC LIMIT 0;

7.52

SELECT COUNT(*) FROM "words" WHERE (UPPER("words"."word"::text) LIKE UPPER('') AND "words"."length" = 0 AND "words"."language" = '' );

56.6s

1,419

Day	Time	Count	Av. Duration
Apr 18	10pm	70	0.04
	11pm	28	0.23
Apr 19	12am	90	0.24
	1am	24	0.71
	2am	76	0.01
	3am	29	0.01
	4am	94	0.01
	5am	45	0.00
	6am	87	0.02
	7am	43	0.01
	8am	101	0.00
	9am	25	0.01
	10am	113	0.00
	11am	35	0.03
	12pm	121	0.01
	1pm	67	0.01
	2pm	123	0.00
	3pm	80	0.01
	4pm	131	0.00
	5pm	36	0.01
	6pm	1	0.00

0.04

SELECT "plog_blogcomment"."id", "plog_blogcomment"."oid", "plog_blogcomment"."blogitem_id", "plog_blogcomment"."parent_id", "plog_blogcomment"."approved", "plog_blogcomment"."comment", "plog_blogcomment"."comment_rendered", "plog_blogcomment"."add_date", "plog_blogcomment"."name", "plog_blogcomment"."email", "plog_blogcomment"."user_agent", "plog_blogcomment"."ip_address", "plog_blogcomment"."akismet_pass" FROM "plog_blogcomment" LEFT OUTER JOIN "plog_blogcomment" T3 ON ("plog_blogcomment"."parent_id" = T3."id") WHERE ("plog_blogcomment"."blogitem_id" = 0 AND "plog_blogcomment"."approved" = true AND T3."id" IS NULL) ORDER BY "plog_blogcomment"."add_date" ASC;

14.24s | SELECT "plog_blogcomment"."id", "plog_blogcomment"."oid", "plog_blogcomment"."blogitem_id", "plog_blogcomment"."parent_id", "plog_blogcomment"."approved", "plog_blogcomment"."comment", "plog_blogcomment"."comment_rendered", "plog_blogcomment"."add_date", "plog_blogcomment"."name", "plog_blogcomment"."email", "plog_blogcomment"."user_agent", "plog_blogcomment"."ip_address", "plog_blogcomment"."akismet_pass" FROM "plog_blogcomment" LEFT OUTER JOIN "plog_blogcomment" T3 ON ("plog_blogcomment"."parent_id" = T3."id") WHERE ("plog_blogcomment"."blogitem_id" = 248 AND "plog_blogcomment"."approved" = true AND T3."id" IS NULL) ORDER BY "plog_blogcomment"."add_date" ASC;

6.69s | SELECT "plog_blogcomment"."id", "plog_blogcomment"."oid", "plog_blogcomment"."blogitem_id", "plog_blogcomment"."parent_id", "plog_blogcomment"."approved", "plog_blogcomment"."comment", "plog_blogcomment"."comment_rendered", "plog_blogcomment"."add_date", "plog_blogcomment"."name", "plog_blogcomment"."email", "plog_blogcomment"."user_agent", "plog_blogcomment"."ip_address", "plog_blogcomment"."akismet_pass" FROM "plog_blogcomment" LEFT OUTER JOIN "plog_blogcomment" T3 ON ("plog_blogcomment"."parent_id" = T3."id") WHERE ("plog_blogcomment"."blogitem_id" = 864 AND "plog_blogcomment"."approved" = true AND T3."id" IS NULL) ORDER BY "plog_blogcomment"."add_date" ASC;

4.67s | SELECT "plog_blogcomment"."id", "plog_blogcomment"."oid", "plog_blogcomment"."blogitem_id", "plog_blogcomment"."parent_id", "plog_blogcomment"."approved", "plog_blogcomment"."comment", "plog_blogcomment"."comment_rendered", "plog_blogcomment"."add_date", "plog_blogcomment"."name", "plog_blogcomment"."email", "plog_blogcomment"."user_agent", "plog_blogcomment"."ip_address", "plog_blogcomment"."akismet_pass" FROM "plog_blogcomment" LEFT OUTER JOIN "plog_blogcomment" T3 ON ("plog_blogcomment"."parent_id" = T3."id") WHERE ("plog_blogcomment"."blogitem_id" = 864 AND "plog_blogcomment"."approved" = true AND T3."id" IS NULL) ORDER BY "plog_blogcomment"."add_date" ASC;

46.9s

Day	Time	Count	Av. Duration
Apr 19	3am	1	0.45
	5am	1	0.66
	6am	1	0.81
	7am	1	0.82
	10am	1	0.26
	11am	2	0.48
	12pm	2	4.54
	1pm	2	0.14
	4pm	1	0.26
	5pm	1	33.28

3.60

SELECT "searches"."id", "searches"."search_word", "searches"."add_date", "searches"."user_agent", "searches"."ip_address", "searches"."language", "searches"."search_type", "searches"."found_word_id", "words"."id", "words"."word", "words"."language", "words"."length", "words"."part_of_speech", "words"."definition", "words"."name" FROM "searches" LEFT OUTER JOIN "words" ON ("searches"."found_word_id" = "words"."id") WHERE ("searches"."add_date" >= '' AND "searches"."add_date" < '' AND NOT ("searches"."found_word_id" IS NULL) AND NOT (("words"."word" IN (...) AND NOT ("words"."id" IS NULL))));

33.28s | SELECT "searches"."id", "searches"."search_word", "searches"."add_date", "searches"."user_agent", "searches"."ip_address", "searches"."language", "searches"."search_type", "searches"."found_word_id", "words"."id", "words"."word", "words"."language", "words"."length", "words"."part_of_speech", "words"."definition", "words"."name" FROM "searches" LEFT OUTER JOIN "words" ON ("searches"."found_word_id" = "words"."id") WHERE ("searches"."add_date" >= '2012-03-01 00:00:00' AND "searches"."add_date" < '2012-04-01 00:00:00' AND NOT ("searches"."found_word_id" IS NULL) AND NOT (("words"."word" IN ('crossword', 'korsord', 'fuck', 'peter', 'motherfucker') AND NOT ("words"."id" IS NULL))));

8.59s | SELECT "searches"."id", "searches"."search_word", "searches"."add_date", "searches"."user_agent", "searches"."ip_address", "searches"."language", "searches"."search_type", "searches"."found_word_id", "words"."id", "words"."word", "words"."language", "words"."length", "words"."part_of_speech", "words"."definition", "words"."name" FROM "searches" LEFT OUTER JOIN "words" ON ("searches"."found_word_id" = "words"."id") WHERE ("searches"."add_date" >= '2011-06-01 00:00:00' AND "searches"."add_date" < '2011-07-01 00:00:00' AND NOT ("searches"."found_word_id" IS NULL) AND NOT (("words"."word" IN ('crossword', 'korsord', 'fuck', 'peter', 'motherfucker') AND NOT ("words"."id" IS NULL))));

0.82s | SELECT "searches"."id", "searches"."search_word", "searches"."add_date", "searches"."user_agent", "searches"."ip_address", "searches"."language", "searches"."search_type", "searches"."found_word_id", "words"."id", "words"."word", "words"."language", "words"."length", "words"."part_of_speech", "words"."definition", "words"."name" FROM "searches" LEFT OUTER JOIN "words" ON ("searches"."found_word_id" = "words"."id") WHERE ("searches"."add_date" >= '2011-09-01 00:00:00' AND "searches"."add_date" < '2011-10-01 00:00:00' AND NOT ("searches"."found_word_id" IS NULL) AND NOT (("words"."word" IN ('crossword', 'korsord', 'fuck', 'peter', 'motherfucker') AND NOT ("words"."id" IS NULL))));

39.5s

140

Day	Time	Count	Av. Duration
Apr 18	10pm	3	0.23
	11pm	14	0.17
Apr 19	12am	11	2.52
	1am	11	0.33
	2am	20	0.06
	3am	11	0.10
	4am	12	0.01
	5am	8	0.01
	6am	11	0.06
	7am	12	0.02
	10am	4	0.03
	12pm	7	0.06
	1pm	7	0.08
	2pm	8	0.04
	3pm	1	0.16

0.28

SELECT COUNT(*) FROM "plog_blogitem" WHERE to_tsvector('',title) @@ to_tsquery('', '');

34.5s

865

Day	Time	Count	Av. Duration
Apr 18	10pm	27	0.04
	11pm	69	0.34
Apr 19	12am	45	0.03
	1am	24	0.14
	2am	29	0.01
	3am	61	0.00
	4am	28	0.00
	5am	31	0.00
	6am	52	0.00
	7am	60	0.00
	8am	39	0.00
	9am	31	0.00
	10am	47	0.01
	11am	71	0.01
	12pm	26	0.08
	1pm	29	0.01
	2pm	42	0.00
	3pm	75	0.00
	4pm	42	0.00
	5pm	37	0.01

0.04

34.0s

1,434

Day	Time	Count	Av. Duration
Apr 18	10pm	71	0.08
	11pm	28	0.10
Apr 19	12am	90	0.18
	1am	24	0.05
	2am	77	0.01
	3am	29	0.00
	4am	94	0.00
	5am	45	0.01
	6am	87	0.01
	7am	43	0.01
	8am	101	0.00
	9am	25	0.01
	10am	124	0.00
	11am	35	0.00
	12pm	121	0.03
	1pm	67	0.00
	2pm	123	0.01
	3pm	81	0.00
	4pm	131	0.00
	5pm	37	0.00
	6pm	1	0.00

0.02

4.49s | SELECT "plog_blogitem"."id", "plog_blogitem"."oid", "plog_blogitem"."title", "plog_blogitem"."alias", "plog_blogitem"."bookmark", "plog_blogitem"."text", "plog_blogitem"."text_rendered", "plog_blogitem"."summary", "plog_blogitem"."url", "plog_blogitem"."pub_date", "plog_blogitem"."display_format", "plog_blogitem"."keywords", "plog_blogitem"."plogrank", "plog_blogitem"."codesyntax", "plog_blogitem"."disallow_comments", "plog_blogitem"."hide_comments", "plog_blogitem"."modify_date" FROM "plog_blogitem" WHERE ("plog_blogitem"."pub_date" < '2010-05-24 04:00:00+00:00' OR ("plog_blogitem"."id" < 864 AND "plog_blogitem"."pub_date" = '2010-05-24 04:00:00+00:00' )) ORDER BY "plog_blogitem"."pub_date" DESC, "plog_blogitem"."id" DESC LIMIT 1;

4.12s | SELECT "plog_blogitem"."id", "plog_blogitem"."oid", "plog_blogitem"."title", "plog_blogitem"."alias", "plog_blogitem"."bookmark", "plog_blogitem"."text", "plog_blogitem"."text_rendered", "plog_blogitem"."summary", "plog_blogitem"."url", "plog_blogitem"."pub_date", "plog_blogitem"."display_format", "plog_blogitem"."keywords", "plog_blogitem"."plogrank", "plog_blogitem"."codesyntax", "plog_blogitem"."disallow_comments", "plog_blogitem"."hide_comments", "plog_blogitem"."modify_date" FROM "plog_blogitem" WHERE ("plog_blogitem"."pub_date" < '2004-03-08 16:00:00+00:00' OR ("plog_blogitem"."id" < 189 AND "plog_blogitem"."pub_date" = '2004-03-08 16:00:00+00:00' )) ORDER BY "plog_blogitem"."pub_date" DESC, "plog_blogitem"."id" DESC LIMIT 1;

2.23s | SELECT "plog_blogitem"."id", "plog_blogitem"."oid", "plog_blogitem"."title", "plog_blogitem"."alias", "plog_blogitem"."bookmark", "plog_blogitem"."text", "plog_blogitem"."text_rendered", "plog_blogitem"."summary", "plog_blogitem"."url", "plog_blogitem"."pub_date", "plog_blogitem"."display_format", "plog_blogitem"."keywords", "plog_blogitem"."plogrank", "plog_blogitem"."codesyntax", "plog_blogitem"."disallow_comments", "plog_blogitem"."hide_comments", "plog_blogitem"."modify_date" FROM "plog_blogitem" WHERE ("plog_blogitem"."pub_date" < '2009-07-20 22:00:00+00:00' OR ("plog_blogitem"."id" < 807 AND "plog_blogitem"."pub_date" = '2009-07-20 22:00:00+00:00' )) ORDER BY "plog_blogitem"."pub_date" DESC, "plog_blogitem"."id" DESC LIMIT 1;

28.7s

4,139

Day	Time	Count	Av. Duration
Apr 18	10pm	158	0.00
	11pm	252	0.04
Apr 19	12am	238	0.07
	1am	125	0.00
	2am	177	0.00
	3am	176	0.00
	4am	210	0.00
	5am	205	0.00
	6am	240	0.00
	7am	186	0.00
	8am	208	0.00
	9am	111	0.00
	10am	260	0.00
	11am	254	0.00
	12pm	236	0.00
	1pm	180	0.00
	2pm	213	0.00
	3pm	292	0.00
	4pm	227	0.00
	5pm	189	0.00
	6pm	2	0.00

0.01

SET DATESTYLE TO '';

28.1s

472

Day	Time	Count	Av. Duration
Apr 18	10pm	16	0.06
	11pm	19	0.73
Apr 19	12am	29	0.21
	1am	16	0.05
	2am	10	0.02
	3am	22	0.03
	4am	20	0.01
	5am	37	0.01
	6am	22	0.05
	7am	34	0.01
	8am	38	0.01
	9am	13	0.03
	10am	37	0.01
	11am	24	0.01
	12pm	25	0.07
	1pm	16	0.01
	2pm	18	0.02
	3pm	27	0.01
	4pm	30	0.00
	5pm	19	0.00

0.06

SELECT "plog_blogcomment"."id", "plog_blogcomment"."oid", "plog_blogcomment"."blogitem_id", "plog_blogcomment"."parent_id", "plog_blogcomment"."approved", "plog_blogcomment"."comment", "plog_blogcomment"."comment_rendered", "plog_blogcomment"."add_date", "plog_blogcomment"."name", "plog_blogcomment"."email", "plog_blogcomment"."user_agent", "plog_blogcomment"."ip_address", "plog_blogcomment"."akismet_pass" FROM "plog_blogcomment" WHERE ("plog_blogcomment"."blogitem_id" = 0 AND "plog_blogcomment"."add_date" > '' ) ORDER BY "plog_blogcomment"."add_date" DESC LIMIT 0;

22.3s

Day	Time	Count	Av. Duration
Apr 18	10pm	2	2.51
	11pm	5	2.95
Apr 19	12am	1	0.32
	1am	2	0.72
	7am	1	0.08
	11am	2	0.28
	1pm	1	0.13

1.59

SELECT COUNT(*) FROM "words" WHERE (UPPER("words"."word"::text) LIKE UPPER('') AND UPPER("words"."word"::text) LIKE UPPER('') AND "words"."length" = 0 AND "words"."language" = '' );

18.9s

60,849

Day	Time	Count
Apr 18	10pm	10,680
	11pm	6,214
Apr 19	12am	263
	1am	5,328
	2am	3,260
	3am	142
	4am	472
	5am	302
	6am	234
	7am	2,269
	8am	322
	9am	207
	10am	7,979
	11am	5,349
	12pm	1,553
	1pm	300
	2pm	354
	3pm	1,118
	4pm	3,129
	5pm	11,371
	6pm	3

0.00

SELECT "plog_blogcomment"."id", "plog_blogcomment"."oid", "plog_blogcomment"."blogitem_id", "plog_blogcomment"."parent_id", "plog_blogcomment"."approved", "plog_blogcomment"."comment", "plog_blogcomment"."comment_rendered", "plog_blogcomment"."add_date", "plog_blogcomment"."name", "plog_blogcomment"."email", "plog_blogcomment"."user_agent", "plog_blogcomment"."ip_address", "plog_blogcomment"."akismet_pass" FROM "plog_blogcomment" WHERE ("plog_blogcomment"."approved" = true AND "plog_blogcomment"."parent_id" = 0 ) ORDER BY "plog_blogcomment"."add_date" ASC;

15.8s

Day	Time	Count	Av. Duration
Apr 18	10pm	1	0.64
	11pm	35	0.09
Apr 19	12am	4	1.35
	1am	2	0.80
	5am	7	0.10
	8am	11	0.05
	9am	6	0.05
	11am	15	0.17
	12pm	2	0.13
	1pm	11	0.01
	4pm	1	0.67

0.17

SELECT "searches"."id", "searches"."search_word", "searches"."add_date", "searches"."user_agent", "searches"."ip_address", "searches"."language", "searches"."search_type", "searches"."found_word_id", "words"."id", "words"."word", "words"."language", "words"."length", "words"."part_of_speech", "words"."definition", "words"."name" FROM "searches" LEFT OUTER JOIN "words" ON ("searches"."found_word_id" = "words"."id") WHERE ("words"."id" IS NOT NULL AND "searches"."language" = '' AND "searches"."add_date" < '' AND "searches"."add_date" >= '' AND NOT (("words"."word" IN (...) AND NOT ("words"."id" IS NULL)) AND "searches"."ip_address" = '' AND "searches"."user_agent" = '' ));

5.24s | SELECT "searches"."id", "searches"."search_word", "searches"."add_date", "searches"."user_agent", "searches"."ip_address", "searches"."language", "searches"."search_type", "searches"."found_word_id", "words"."id", "words"."word", "words"."language", "words"."length", "words"."part_of_speech", "words"."definition", "words"."name" FROM "searches" LEFT OUTER JOIN "words" ON ("searches"."found_word_id" = "words"."id") WHERE ("words"."id" IS NOT NULL AND "searches"."language" = 'en-us' AND "searches"."add_date" < '2012-04-19 00:13:07.191241' AND "searches"."add_date" >= '2012-04-01 00:00:00' AND NOT (("words"."word" IN ('crossword', 'korsord', 'fuck', 'peter', 'motherfucker') AND NOT ("words"."id" IS NULL)) AND "searches"."ip_address" = '68.58.112.227' AND "searches"."user_agent" = 'Mozilla/5.0 (Windows NT 5.1; rv:11.0) Gecko/20100101 Firefox/11.0' ));

2.19s | SELECT "searches"."id", "searches"."search_word", "searches"."add_date", "searches"."user_agent", "searches"."ip_address", "searches"."language", "searches"."search_type", "searches"."found_word_id", "words"."id", "words"."word", "words"."language", "words"."length", "words"."part_of_speech", "words"."definition", "words"."name" FROM "searches" LEFT OUTER JOIN "words" ON ("searches"."found_word_id" = "words"."id") WHERE ("words"."id" IS NOT NULL AND "searches"."language" = 'fr' AND "searches"."add_date" < '2012-04-19 11:10:52.990564' AND "searches"."add_date" >= '2012-04-01 00:00:00' AND NOT (("words"."word" IN ('crossword', 'korsord', 'fuck', 'peter', 'motherfucker') AND NOT ("words"."id" IS NULL)) AND "searches"."ip_address" = '92.133.69.211' AND "searches"."user_agent" = 'Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.0; Trident/5.0)' ));

1.13s | SELECT "searches"."id", "searches"."search_word", "searches"."add_date", "searches"."user_agent", "searches"."ip_address", "searches"."language", "searches"."search_type", "searches"."found_word_id", "words"."id", "words"."word", "words"."language", "words"."length", "words"."part_of_speech", "words"."definition", "words"."name" FROM "searches" LEFT OUTER JOIN "words" ON ("searches"."found_word_id" = "words"."id") WHERE ("words"."id" IS NOT NULL AND "searches"."language" = 'en-us' AND "searches"."add_date" < '2012-04-19 01:22:16.269985' AND "searches"."add_date" >= '2012-04-01 00:00:00' AND NOT (("words"."word" IN ('crossword', 'korsord', 'fuck', 'peter', 'motherfucker') AND NOT ("words"."id" IS NULL)) AND "searches"."ip_address" = '216.113.222.163' AND "searches"."user_agent" = 'Mozilla/5.0 (iPod; CPU iPhone OS 5_1 like Mac OS X) AppleWebKit/534.46 (KHTML, like Gecko) Version/5.1 Mobile/9B176 Safari/7534.48.3' ));

15.0s

221

Day	Time	Count	Av. Duration
Apr 18	10pm	3	0.16
	11pm	26	0.33
Apr 19	12am	8	0.11
	1am	8	0.05
	2am	5	0.08
	3am	7	0.08
	4am	4	0.06
	5am	11	0.01
	6am	9	0.01
	7am	6	0.01
	8am	16	0.00
	9am	13	0.01
	10am	5	0.01
	11am	42	0.02
	12pm	16	0.06
	1pm	16	0.02
	2pm	6	0.03
	3pm	3	0.17
	4pm	8	0.01
	5pm	9	0.04

0.07

SELECT COUNT(*) FROM "searches" WHERE ("searches"."add_date" >= '' AND "searches"."language" = '' );

14.2s

1,446

Day	Time	Count	Av. Duration
Apr 18	10pm	71	0.01
	11pm	28	0.10
Apr 19	12am	90	0.05
	1am	24	0.17
	2am	77	0.00
	3am	29	0.00
	4am	94	0.00
	5am	45	0.00
	6am	87	0.00
	7am	43	0.00
	8am	101	0.00
	9am	25	0.00
	10am	124	0.00
	11am	35	0.00
	12pm	121	0.01
	1pm	67	0.00
	2pm	123	0.00
	3pm	93	0.00
	4pm	131	0.00
	5pm	37	0.00
	6pm	1	0.00

0.01

SELECT "plog_category"."id", "plog_category"."name" FROM "plog_category" INNER JOIN "plog_blogitem_categories" ON ("plog_category"."id" = "plog_blogitem_categories"."category_id") WHERE "plog_blogitem_categories"."blogitem_id" = 0;

13.3s

142

Day	Time	Count	Av. Duration
Apr 18	10pm	3	0.07
	11pm	8	1.35
Apr 19	12am	5	0.02
	1am	5	0.21
	2am	5	0.04
	3am	9	0.02
	4am	4	0.01
	5am	10	0.00
	6am	6	0.00
	7am	8	0.01
	8am	6	0.01
	9am	5	0.01
	10am	6	0.01
	11am	5	0.01
	12pm	9	0.01
	1pm	6	0.01
	2pm	6	0.00
	3pm	13	0.02
	4pm	12	0.00
	5pm	11	0.00

0.09

8.94s | SELECT "plog_blogitem"."id", "plog_blogitem"."oid", "plog_blogitem"."title", "plog_blogitem"."alias", "plog_blogitem"."bookmark", "plog_blogitem"."text", "plog_blogitem"."text_rendered", "plog_blogitem"."summary", "plog_blogitem"."url", "plog_blogitem"."pub_date", "plog_blogitem"."display_format", "plog_blogitem"."keywords", "plog_blogitem"."plogrank", "plog_blogitem"."codesyntax", "plog_blogitem"."disallow_comments", "plog_blogitem"."hide_comments", "plog_blogitem"."modify_date" FROM "plog_blogitem" INNER JOIN "plog_blogitem_categories" ON ("plog_blogitem"."id" = "plog_blogitem_categories"."blogitem_id") WHERE ("plog_blogitem"."pub_date" < '2012-04-18 23:24:32.097483+00:00' AND "plog_blogitem_categories"."category_id" = 23 ) ORDER BY "plog_blogitem"."pub_date" DESC LIMIT 10;

1.39s | SELECT "plog_blogitem"."id", "plog_blogitem"."oid", "plog_blogitem"."title", "plog_blogitem"."alias", "plog_blogitem"."bookmark", "plog_blogitem"."text", "plog_blogitem"."text_rendered", "plog_blogitem"."summary", "plog_blogitem"."url", "plog_blogitem"."pub_date", "plog_blogitem"."display_format", "plog_blogitem"."keywords", "plog_blogitem"."plogrank", "plog_blogitem"."codesyntax", "plog_blogitem"."disallow_comments", "plog_blogitem"."hide_comments", "plog_blogitem"."modify_date" FROM "plog_blogitem" INNER JOIN "plog_blogitem_categories" ON ("plog_blogitem"."id" = "plog_blogitem_categories"."blogitem_id") WHERE ("plog_blogitem"."pub_date" < '2012-04-18 23:24:42.234036+00:00' AND "plog_blogitem_categories"."category_id" = 18 ) ORDER BY "plog_blogitem"."pub_date" DESC LIMIT 10;

0.56s | SELECT "plog_blogitem"."id", "plog_blogitem"."oid", "plog_blogitem"."title", "plog_blogitem"."alias", "plog_blogitem"."bookmark", "plog_blogitem"."text", "plog_blogitem"."text_rendered", "plog_blogitem"."summary", "plog_blogitem"."url", "plog_blogitem"."pub_date", "plog_blogitem"."display_format", "plog_blogitem"."keywords", "plog_blogitem"."plogrank", "plog_blogitem"."codesyntax", "plog_blogitem"."disallow_comments", "plog_blogitem"."hide_comments", "plog_blogitem"."modify_date" FROM "plog_blogitem" INNER JOIN "plog_blogitem_categories" ON ("plog_blogitem"."id" = "plog_blogitem_categories"."blogitem_id") WHERE ("plog_blogitem"."pub_date" < '2012-04-19 01:47:37.049422+00:00' AND "plog_blogitem_categories"."category_id" = 18 ) ORDER BY "plog_blogitem"."pub_date" DESC LIMIT 10;

12.3s

4,139

Day	Time	Count	Av. Duration
Apr 18	10pm	158	0.00
	11pm	252	0.03
Apr 19	12am	238	0.01
	1am	125	0.00
	2am	177	0.00
	3am	176	0.00
	4am	210	0.00
	5am	205	0.00
	6am	240	0.00
	7am	186	0.00
	8am	208	0.00
	9am	111	0.00
	10am	260	0.00
	11am	254	0.00
	12pm	236	0.00
	1pm	180	0.00
	2pm	213	0.00
	3pm	292	0.00
	4pm	227	0.00
	5pm	189	0.00
	6pm	2	0.00

0.00

SHOW client_encoding;

Slowest queries ^

Rank	Duration (s)	Query
1	1,134.22	SELECT "words"."id", "words"."word", "words"."language", "words"."length", "words"."part_of_speech", "words"."definition", "words"."name" FROM "words" WHERE ("words"."length" = 6 AND "words"."language" = 'en-us' AND UPPER("words"."word"::text) LIKE UPPER('%tere%') ) ORDER BY "words"."word" ASC LIMIT 1000;
2	144.61	SELECT "words"."id", "words"."word", "words"."language", "words"."length", "words"."part_of_speech", "words"."definition", "words"."name" FROM "words" WHERE ("words"."length" = 4 AND "words"."language" = 'en-us' );
3	133.42	SELECT "words"."id", "words"."word", "words"."language", "words"."length", "words"."part_of_speech", "words"."definition", "words"."name" FROM "words" WHERE ("words"."length" = 6 AND "words"."language" = 'en-us' );
4	97.01	SELECT "words"."id", "words"."word", "words"."language", "words"."length", "words"."part_of_speech", "words"."definition", "words"."name" FROM "words" WHERE ("words"."length" = 3 AND "words"."language" = 'en-us' );
5	88.40	SELECT "plog_blogitem"."id", "plog_blogitem"."oid", "plog_blogitem"."title", "plog_blogitem"."alias", "plog_blogitem"."bookmark", "plog_blogitem"."text", "plog_blogitem"."text_rendered", "plog_blogitem"."summary", "plog_blogitem"."url", "plog_blogitem"."pub_date", "plog_blogitem"."display_format", "plog_blogitem"."keywords", "plog_blogitem"."plogrank", "plog_blogitem"."codesyntax", "plog_blogitem"."disallow_comments", "plog_blogitem"."hide_comments", "plog_blogitem"."modify_date" FROM "plog_blogitem" WHERE "plog_blogitem"."id" IN (854, 889, 949, 928, 923, 872);
6	87.54	SELECT "words"."id", "words"."word", "words"."language", "words"."length", "words"."part_of_speech", "words"."definition", "words"."name" FROM "words" WHERE ("words"."length" = 6 AND "words"."language" = 'en-us' AND UPPER("words"."word"::text) LIKE UPPER('%tere%') ) ORDER BY "words"."word" ASC LIMIT 1000;
7	58.44	SELECT COUNT(*) FROM "words" WHERE (UPPER("words"."word"::text) LIKE UPPER('%t%') AND "words"."length" = 7 AND "words"."language" = 'fr' );
8	57.84	SELECT "words"."id", "words"."word", "words"."language", "words"."length", "words"."part_of_speech", "words"."definition", "words"."name" FROM "words" WHERE ("words"."length" = 3 AND "words"."language" = 'en-us' );
9	49.59	SELECT "words"."id", "words"."word", "words"."language", "words"."length", "words"."part_of_speech", "words"."definition", "words"."name" FROM "words" WHERE ("words"."length" = 6 AND "words"."language" = 'en-us' );
10	46.75	SELECT "words"."id", "words"."word", "words"."language", "words"."length", "words"."part_of_speech", "words"."definition", "words"."name" FROM "words" WHERE ("words"."length" = 9 AND "words"."language" = 'en-us' AND UPPER("words"."word"::text) LIKE UPPER('%ss%') ) ORDER BY "words"."word" ASC LIMIT 1000;
11	33.28	SELECT "searches"."id", "searches"."search_word", "searches"."add_date", "searches"."user_agent", "searches"."ip_address", "searches"."language", "searches"."search_type", "searches"."found_word_id", "words"."id", "words"."word", "words"."language", "words"."length", "words"."part_of_speech", "words"."definition", "words"."name" FROM "searches" LEFT OUTER JOIN "words" ON ("searches"."found_word_id" = "words"."id") WHERE ("searches"."add_date" >= '2012-03-01 00:00:00' AND "searches"."add_date" < '2012-04-01 00:00:00' AND NOT ("searches"."found_word_id" IS NULL) AND NOT (("words"."word" IN ('crossword', 'korsord', 'fuck', 'peter', 'motherfucker') AND NOT ("words"."id" IS NULL))));
12	29.77	SELECT "plog_blogitem"."id", "plog_blogitem"."oid", "plog_blogitem"."title", "plog_blogitem"."alias", "plog_blogitem"."bookmark", "plog_blogitem"."text", "plog_blogitem"."text_rendered", "plog_blogitem"."summary", "plog_blogitem"."url", "plog_blogitem"."pub_date", "plog_blogitem"."display_format", "plog_blogitem"."keywords", "plog_blogitem"."plogrank", "plog_blogitem"."codesyntax", "plog_blogitem"."disallow_comments", "plog_blogitem"."hide_comments", "plog_blogitem"."modify_date" FROM "plog_blogitem" WHERE "plog_blogitem"."oid" = 'mongoengine-vs.-django-mongokit';
13	21.94	SELECT COUNT(*) FROM "plog_blogitem" WHERE to_tsvector('english',title) @@ to_tsquery('english', 'i & cant & stop & thinking & about & you');
14	21.24	SELECT "words"."id", "words"."word", "words"."language", "words"."length", "words"."part_of_speech", "words"."definition", "words"."name" FROM "words" WHERE ("words"."length" = 3 AND "words"."language" = 'en-us' );
15	19.02	SELECT "words"."id", "words"."word", "words"."language", "words"."length", "words"."part_of_speech", "words"."definition", "words"."name" FROM "words" WHERE ("words"."length" = 8 AND UPPER("words"."word"::text) LIKE UPPER('e%') AND "words"."language" = 'en-us' AND UPPER("words"."word"::text) LIKE UPPER('%l%') ) ORDER BY "words"."word" ASC LIMIT 2500;
16	16.17	SELECT "words"."id", "words"."word", "words"."language", "words"."length", "words"."part_of_speech", "words"."definition", "words"."name" FROM "words" WHERE ("words"."length" = 10 AND UPPER("words"."word"::text) LIKE UPPER('%or') AND "words"."language" = 'en-us' AND UPPER("words"."word"::text) LIKE UPPER('%om%') ) ORDER BY "words"."word" ASC LIMIT 2500;
17	16.08	SELECT "words"."id", "words"."word", "words"."language", "words"."length", "words"."part_of_speech", "words"."definition", "words"."name" FROM "words" WHERE ("words"."length" = 6 AND "words"."language" = 'en-us' );
18	14.24	SELECT "plog_blogcomment"."id", "plog_blogcomment"."oid", "plog_blogcomment"."blogitem_id", "plog_blogcomment"."parent_id", "plog_blogcomment"."approved", "plog_blogcomment"."comment", "plog_blogcomment"."comment_rendered", "plog_blogcomment"."add_date", "plog_blogcomment"."name", "plog_blogcomment"."email", "plog_blogcomment"."user_agent", "plog_blogcomment"."ip_address", "plog_blogcomment"."akismet_pass" FROM "plog_blogcomment" LEFT OUTER JOIN "plog_blogcomment" T3 ON ("plog_blogcomment"."parent_id" = T3."id") WHERE ("plog_blogcomment"."blogitem_id" = 248 AND "plog_blogcomment"."approved" = true AND T3."id" IS NULL) ORDER BY "plog_blogcomment"."add_date" ASC;
19	12.44	SELECT "words"."id", "words"."word", "words"."language", "words"."length", "words"."part_of_speech", "words"."definition", "words"."name" FROM "words" WHERE ("words"."length" = 4 AND "words"."language" = 'en-us' );
20	9.82	SELECT "plog_blogitem"."id", "plog_blogitem"."oid", "plog_blogitem"."title", "plog_blogitem"."alias", "plog_blogitem"."bookmark", "plog_blogitem"."text", "plog_blogitem"."text_rendered", "plog_blogitem"."summary", "plog_blogitem"."url", "plog_blogitem"."pub_date", "plog_blogitem"."display_format", "plog_blogitem"."keywords", "plog_blogitem"."plogrank", "plog_blogitem"."codesyntax", "plog_blogitem"."disallow_comments", "plog_blogitem"."hide_comments", "plog_blogitem"."modify_date" FROM "plog_blogitem" WHERE "plog_blogitem"."pub_date" < '2012-04-19 12:00:13.202440+00:00' ORDER BY "plog_blogitem"."pub_date" DESC LIMIT 10 OFFSET 940;

Most frequent queries (N) ^

Rank

Times executed

Total duration

Av. duration (s)

Query

60,849

Day	Time	Count
Apr 18	10pm	10,680
	11pm	6,214
Apr 19	12am	263
	1am	5,328
	2am	3,260
	3am	142
	4am	472
	5am	302
	6am	234
	7am	2,269
	8am	322
	9am	207
	10am	7,979
	11am	5,349
	12pm	1,553
	1pm	300
	2pm	354
	3pm	1,118
	4pm	3,129
	5pm	11,371
	6pm	3

18.9s

0.00

SELECT "plog_blogcomment"."id", "plog_blogcomment"."oid", "plog_blogcomment"."blogitem_id", "plog_blogcomment"."parent_id", "plog_blogcomment"."approved", "plog_blogcomment"."comment", "plog_blogcomment"."comment_rendered", "plog_blogcomment"."add_date", "plog_blogcomment"."name", "plog_blogcomment"."email", "plog_blogcomment"."user_agent", "plog_blogcomment"."ip_address", "plog_blogcomment"."akismet_pass" FROM "plog_blogcomment" WHERE ("plog_blogcomment"."approved" = true AND "plog_blogcomment"."parent_id" = 0 ) ORDER BY "plog_blogcomment"."add_date" ASC;

4,139

Day	Time	Count	Av. Duration
Apr 18	10pm	158	0.00
	11pm	252	0.04
Apr 19	12am	238	0.07
	1am	125	0.00
	2am	177	0.00
	3am	176	0.00
	4am	210	0.00
	5am	205	0.00
	6am	240	0.00
	7am	186	0.00
	8am	208	0.00
	9am	111	0.00
	10am	260	0.00
	11am	254	0.00
	12pm	236	0.00
	1pm	180	0.00
	2pm	213	0.00
	3pm	292	0.00
	4pm	227	0.00
	5pm	189	0.00
	6pm	2	0.00

28.7s

0.01

SET DATESTYLE TO '';

4,139

Day	Time	Count	Av. Duration
Apr 18	10pm	158	0.00
	11pm	252	0.03
Apr 19	12am	238	0.01
	1am	125	0.00
	2am	177	0.00
	3am	176	0.00
	4am	210	0.00
	5am	205	0.00
	6am	240	0.00
	7am	186	0.00
	8am	208	0.00
	9am	111	0.00
	10am	260	0.00
	11am	254	0.00
	12pm	236	0.00
	1pm	180	0.00
	2pm	213	0.00
	3pm	292	0.00
	4pm	227	0.00
	5pm	189	0.00
	6pm	2	0.00

12.3s

0.00

SHOW client_encoding;

4,139

Day	Time	Count
Apr 18	10pm	158
	11pm	252
Apr 19	12am	238
	1am	125
	2am	177
	3am	176
	4am	210
	5am	205
	6am	240
	7am	186
	8am	208
	9am	111
	10am	260
	11am	254
	12pm	236
	1pm	180
	2pm	213
	3pm	292
	4pm	227
	5pm	189
	6pm	2

0.2s

0.00

SHOW default_transaction_isolation;

2,521

Day	Time	Count	Av. Duration
Apr 18	10pm	104	0.13
	11pm	68	0.17
Apr 19	12am	171	0.32
	1am	55	0.04
	2am	102	0.00
	3am	60	0.00
	4am	143	0.00
	5am	103	0.00
	6am	121	0.01
	7am	93	0.00
	8am	152	0.00
	9am	60	0.01
	10am	208	0.00
	11am	70	0.01
	12pm	176	0.01
	1pm	148	0.00
	2pm	191	0.00
	3pm	196	0.00
	4pm	206	0.00
	5pm	93	0.00
	6pm	1	0.00

1m27s

0.03

1,446

Day	Time	Count	Av. Duration
Apr 18	10pm	71	0.01
	11pm	28	0.10
Apr 19	12am	90	0.05
	1am	24	0.17
	2am	77	0.00
	3am	29	0.00
	4am	94	0.00
	5am	45	0.00
	6am	87	0.00
	7am	43	0.00
	8am	101	0.00
	9am	25	0.00
	10am	124	0.00
	11am	35	0.00
	12pm	121	0.01
	1pm	67	0.00
	2pm	123	0.00
	3pm	93	0.00
	4pm	131	0.00
	5pm	37	0.00
	6pm	1	0.00

14.2s

0.01

1,434

Day	Time	Count	Av. Duration
Apr 18	10pm	71	0.08
	11pm	28	0.10
Apr 19	12am	90	0.18
	1am	24	0.05
	2am	77	0.01
	3am	29	0.00
	4am	94	0.00
	5am	45	0.01
	6am	87	0.01
	7am	43	0.01
	8am	101	0.00
	9am	25	0.01
	10am	124	0.00
	11am	35	0.00
	12pm	121	0.03
	1pm	67	0.00
	2pm	123	0.01
	3pm	81	0.00
	4pm	131	0.00
	5pm	37	0.00
	6pm	1	0.00

34.0s

0.02

1,434

Day	Time	Count	Av. Duration
Apr 18	10pm	71	0.01
	11pm	28	0.09
Apr 19	12am	90	0.06
	1am	24	0.02
	2am	77	0.00
	3am	29	0.01
	4am	94	0.00
	5am	45	0.00
	6am	87	0.00
	7am	43	0.00
	8am	101	0.00
	9am	25	0.00
	10am	124	0.00
	11am	35	0.01
	12pm	121	0.00
	1pm	67	0.00
	2pm	123	0.00
	3pm	81	0.00
	4pm	131	0.00
	5pm	37	0.01
	6pm	1	0.00

11.1s

0.01

2.45s | SELECT "plog_blogitem"."id", "plog_blogitem"."oid", "plog_blogitem"."title", "plog_blogitem"."alias", "plog_blogitem"."bookmark", "plog_blogitem"."text", "plog_blogitem"."text_rendered", "plog_blogitem"."summary", "plog_blogitem"."url", "plog_blogitem"."pub_date", "plog_blogitem"."display_format", "plog_blogitem"."keywords", "plog_blogitem"."plogrank", "plog_blogitem"."codesyntax", "plog_blogitem"."disallow_comments", "plog_blogitem"."hide_comments", "plog_blogitem"."modify_date" FROM "plog_blogitem" WHERE ("plog_blogitem"."pub_date" < '2012-04-19 00:10:45.808195+00:00' AND ("plog_blogitem"."pub_date" > '2010-05-24 04:00:00+00:00' OR ("plog_blogitem"."id" > 864 AND "plog_blogitem"."pub_date" = '2010-05-24 04:00:00+00:00' ))) ORDER BY "plog_blogitem"."pub_date" ASC, "plog_blogitem"."id" ASC LIMIT 1;

0.88s | SELECT "plog_blogitem"."id", "plog_blogitem"."oid", "plog_blogitem"."title", "plog_blogitem"."alias", "plog_blogitem"."bookmark", "plog_blogitem"."text", "plog_blogitem"."text_rendered", "plog_blogitem"."summary", "plog_blogitem"."url", "plog_blogitem"."pub_date", "plog_blogitem"."display_format", "plog_blogitem"."keywords", "plog_blogitem"."plogrank", "plog_blogitem"."codesyntax", "plog_blogitem"."disallow_comments", "plog_blogitem"."hide_comments", "plog_blogitem"."modify_date" FROM "plog_blogitem" WHERE ("plog_blogitem"."pub_date" < '2012-04-19 00:12:33.851007+00:00' AND ("plog_blogitem"."pub_date" > '2004-03-08 16:00:00+00:00' OR ("plog_blogitem"."id" > 189 AND "plog_blogitem"."pub_date" = '2004-03-08 16:00:00+00:00' ))) ORDER BY "plog_blogitem"."pub_date" ASC, "plog_blogitem"."id" ASC LIMIT 1;

0.49s | SELECT "plog_blogitem"."id", "plog_blogitem"."oid", "plog_blogitem"."title", "plog_blogitem"."alias", "plog_blogitem"."bookmark", "plog_blogitem"."text", "plog_blogitem"."text_rendered", "plog_blogitem"."summary", "plog_blogitem"."url", "plog_blogitem"."pub_date", "plog_blogitem"."display_format", "plog_blogitem"."keywords", "plog_blogitem"."plogrank", "plog_blogitem"."codesyntax", "plog_blogitem"."disallow_comments", "plog_blogitem"."hide_comments", "plog_blogitem"."modify_date" FROM "plog_blogitem" WHERE ("plog_blogitem"."pub_date" < '2012-04-18 23:24:34.160893+00:00' AND ("plog_blogitem"."pub_date" > '2006-08-14 15:00:00+00:00' OR ("plog_blogitem"."id" > 584 AND "plog_blogitem"."pub_date" = '2006-08-14 15:00:00+00:00' ))) ORDER BY "plog_blogitem"."pub_date" ASC, "plog_blogitem"."id" ASC LIMIT 1;

1,419

Day	Time	Count	Av. Duration
Apr 18	10pm	70	0.04
	11pm	28	0.23
Apr 19	12am	90	0.24
	1am	24	0.71
	2am	76	0.01
	3am	29	0.01
	4am	94	0.01
	5am	45	0.00
	6am	87	0.02
	7am	43	0.01
	8am	101	0.00
	9am	25	0.01
	10am	113	0.00
	11am	35	0.03
	12pm	121	0.01
	1pm	67	0.01
	2pm	123	0.00
	3pm	80	0.01
	4pm	131	0.00
	5pm	36	0.01
	6pm	1	0.00

56.6s

0.04

1,372

Day	Time	Count	Av. Duration
Apr 18	10pm	70	0.01
	11pm	25	0.38
Apr 19	12am	88	1.09
	1am	20	0.03
	2am	76	0.01
	3am	27	0.01
	4am	88	0.00
	5am	43	0.01
	6am	83	0.00
	7am	38	0.00
	8am	98	0.00
	9am	25	0.00
	10am	117	0.00
	11am	32	0.01
	12pm	117	0.01
	1pm	67	0.00
	2pm	120	0.00
	3pm	76	0.00
	4pm	129	0.00
	5pm	32	0.00
	6pm	1	0.00

1m52s

0.08

1,017

Day	Time	Count
Apr 18	10pm	47
	11pm	57
Apr 19	12am	33
	1am	127
	2am	111
	3am	165
	4am	161
	5am	60
	6am	27
	7am	60
	10am	23
	11am	4
	12pm	86
	1pm	19
	2pm	20
	3pm	12
	4pm	5

0.8s

0.00

964

Day	Time	Count
Apr 18	10pm	13
	11pm	104
Apr 19	12am	87
	1am	39
	3am	14
	4am	13
	5am	13
	6am	116
	7am	98
	8am	11
	9am	49
	11am	112
	12pm	12
	1pm	42
	3pm	13
	4pm	14
	5pm	214

2.2s

0.00

SELECT COUNT(*) FROM "searches" WHERE ("searches"."add_date" >= '' AND "searches"."add_date" < '' AND NOT ("searches"."search_word" IN (...)) AND length(search_word)=0);

865

Day	Time	Count	Av. Duration
Apr 18	10pm	27	0.04
	11pm	69	0.34
Apr 19	12am	45	0.03
	1am	24	0.14
	2am	29	0.01
	3am	61	0.00
	4am	28	0.00
	5am	31	0.00
	6am	52	0.00
	7am	60	0.00
	8am	39	0.00
	9am	31	0.00
	10am	47	0.01
	11am	71	0.01
	12pm	26	0.08
	1pm	29	0.01
	2pm	42	0.00
	3pm	75	0.00
	4pm	42	0.00
	5pm	37	0.01

34.5s

0.04

727

Day	Time	Count	Av. Duration
Apr 18	10pm	25	0.00
	11pm	101	0.03
Apr 19	12am	32	0.03
	1am	22	0.01
	2am	16	0.00
	3am	13	0.00
	4am	10	0.00
	5am	29	0.00
	6am	46	0.00
	7am	44	0.00
	8am	38	0.00
	9am	24	0.00
	10am	22	0.00
	11am	90	0.00
	12pm	50	0.01
	1pm	49	0.00
	2pm	16	0.00
	3pm	15	0.00
	4pm	16	0.00
	5pm	69	0.00

5.4s

0.01

SET TIME ZONE '';

708

Day	Time	Count	Av. Duration
Apr 18	10pm	64	0.47
	11pm	44	0.40
Apr 19	12am	32	15.62
	1am	36	1.48
	2am	24	0.10
	3am	28	0.04
	4am	8	0.04
	5am	16	0.04
	6am	72	0.04
	7am	72	0.13
	8am	24	0.05
	9am	4	0.06
	10am	48	0.08
	12pm	48	0.09
	1pm	20	0.07
	4pm	8	0.54
	5pm	160	0.44

11m43s

0.99

580

Day	Time	Count	Av. Duration
Apr 18	10pm	13	0.01
	11pm	12	0.03
Apr 19	12am	24	0.15
	1am	12	0.01
	2am	8	0.00
	3am	23	0.00
	4am	21	0.01
	5am	46	0.01
	6am	31	0.00
	7am	20	0.00
	8am	20	0.00
	9am	10	0.03
	10am	44	0.00
	11am	121	0.00
	12pm	29	0.01
	1pm	12	0.01
	2pm	23	0.02
	3pm	35	0.01
	4pm	27	0.00
	5pm	49	0.01

7.2s

0.01

SELECT COUNT(*) FROM "plog_blogcomment" WHERE ("plog_blogcomment"."blogitem_id" = 0 AND "plog_blogcomment"."approved" = true );

532

Day	Time	Count	Av. Duration
Apr 18	10pm	22	0.00
	11pm	22	0.07
Apr 19	12am	29	0.00
	1am	32	0.01
	2am	26	0.00
	3am	53	0.00
	4am	43	0.00
	5am	78	0.00
	6am	35	0.00
	7am	16	0.00
	8am	15	0.00
	9am	12	0.02
	10am	34	0.00
	11am	18	0.00
	12pm	17	0.00
	1pm	10	0.00
	2pm	8	0.00
	3pm	21	0.00
	4pm	15	0.00
	5pm	25	0.00
	6pm	1	0.00

2.9s

0.01

SELECT "plog_category"."id", "plog_category"."name" FROM "plog_category" WHERE "plog_category"."name" IN (...);

472

Day	Time	Count	Av. Duration
Apr 18	10pm	16	0.06
	11pm	19	0.73
Apr 19	12am	29	0.21
	1am	16	0.05
	2am	10	0.02
	3am	22	0.03
	4am	20	0.01
	5am	37	0.01
	6am	22	0.05
	7am	34	0.01
	8am	38	0.01
	9am	13	0.03
	10am	37	0.01
	11am	24	0.01
	12pm	25	0.07
	1pm	16	0.01
	2pm	18	0.02
	3pm	27	0.01
	4pm	30	0.00
	5pm	19	0.00

28.1s

0.06

SELECT "plog_blogcomment"."id", "plog_blogcomment"."oid", "plog_blogcomment"."blogitem_id", "plog_blogcomment"."parent_id", "plog_blogcomment"."approved", "plog_blogcomment"."comment", "plog_blogcomment"."comment_rendered", "plog_blogcomment"."add_date", "plog_blogcomment"."name", "plog_blogcomment"."email", "plog_blogcomment"."user_agent", "plog_blogcomment"."ip_address", "plog_blogcomment"."akismet_pass" FROM "plog_blogcomment" WHERE ("plog_blogcomment"."blogitem_id" = 0 AND "plog_blogcomment"."add_date" > '' ) ORDER BY "plog_blogcomment"."add_date" DESC LIMIT 0;

237

Day	Time	Count
Apr 18	10pm	3
	11pm	22
Apr 19	12am	18
	1am	9
	3am	4
	4am	3
	5am	3
	6am	31
	7am	24
	8am	4
	9am	11
	11am	27
	12pm	4
	1pm	12
	3pm	3
	4pm	4
	5pm	55

0.4s

0.00

SELECT COUNT(*) FROM "searches" WHERE ("searches"."add_date" >= '' AND "searches"."add_date" < '' AND NOT ("searches"."search_word" IN (...)) AND "searches"."language" = '' );

221

Day	Time	Count	Av. Duration
Apr 18	10pm	3	0.16
	11pm	26	0.33
Apr 19	12am	8	0.11
	1am	8	0.05
	2am	5	0.08
	3am	7	0.08
	4am	4	0.06
	5am	11	0.01
	6am	9	0.01
	7am	6	0.01
	8am	16	0.00
	9am	13	0.01
	10am	5	0.01
	11am	42	0.02
	12pm	16	0.06
	1pm	16	0.02
	2pm	6	0.03
	3pm	3	0.17
	4pm	8	0.01
	5pm	9	0.04

15.0s

0.07

SELECT COUNT(*) FROM "searches" WHERE ("searches"."add_date" >= '' AND "searches"."language" = '' );

Slowest queries (N) ^

Rank

Av. duration (s)

Times executed

Total duration

Query

212.39

21m14s

7.52

SELECT COUNT(*) FROM "words" WHERE (UPPER("words"."word"::text) LIKE UPPER('') AND "words"."length" = 0 AND "words"."language" = '' );

3.60

Day	Time	Count	Av. Duration
Apr 19	3am	1	0.45
	5am	1	0.66
	6am	1	0.81
	7am	1	0.82
	10am	1	0.26
	11am	2	0.48
	12pm	2	4.54
	1pm	2	0.14
	4pm	1	0.26
	5pm	1	33.28

46.9s

1.63

3.3s

SELECT DISTINCT ON ("searches"."language") "searches"."language" FROM "searches" WHERE NOT ("searches"."search_word" IN (...));

1.59

Day	Time	Count	Av. Duration
Apr 18	10pm	2	2.51
	11pm	5	2.95
Apr 19	12am	1	0.32
	1am	2	0.72
	7am	1	0.08
	11am	2	0.28
	1pm	1	0.13

22.3s

SELECT COUNT(*) FROM "words" WHERE (UPPER("words"."word"::text) LIKE UPPER('') AND UPPER("words"."word"::text) LIKE UPPER('') AND "words"."length" = 0 AND "words"."language" = '' );

1.35

Day	Time	Count	Av. Duration
Apr 18	11pm	9	3.78
Apr 19	12am	2	8.60
	1am	1	0.33
	3am	1	0.56
	5am	3	0.23
	7am	3	0.11
	8am	2	0.20
	9am	5	0.28
	11am	17	0.37
	12pm	3	0.24

1m2s

SELECT "words"."id", "words"."word", "words"."language", "words"."length", "words"."part_of_speech", "words"."definition", "words"."name" FROM "words" WHERE ("words"."length" = 0 AND UPPER("words"."word"::text) LIKE UPPER('') AND "words"."language" = '' AND UPPER("words"."word"::text) LIKE UPPER('') ) ORDER BY "words"."word" ASC LIMIT 0;

1.16

2.3s

1.05

8.4s

SELECT "words"."id", "words"."word", "words"."language", "words"."length", "words"."part_of_speech", "words"."definition", "words"."name" FROM "words" WHERE (UPPER("words"."word"::text) LIKE UPPER('') AND "words"."length" = 0 AND "words"."language" = '' ) ORDER BY "words"."word" ASC LIMIT 0;

0.99

708

Day	Time	Count	Av. Duration
Apr 18	10pm	64	0.47
	11pm	44	0.40
Apr 19	12am	32	15.62
	1am	36	1.48
	2am	24	0.10
	3am	28	0.04
	4am	8	0.04
	5am	16	0.04
	6am	72	0.04
	7am	72	0.13
	8am	24	0.05
	9am	4	0.06
	10am	48	0.08
	12pm	48	0.09
	1pm	20	0.07
	4pm	8	0.54
	5pm	160	0.44

11m43s

0.88

1.8s

SELECT DISTINCT ON ("searches"."search_type") "searches"."search_type" FROM "searches" WHERE NOT ("searches"."search_word" IN (...));

0.61

0.6s

INSERT INTO "plog_blogitem" ("oid", "title", "alias", "bookmark", "text", "text_rendered", "summary", "url", "pub_date", "display_format", "keywords", "plogrank", "codesyntax", "disallow_comments", "hide_comments", "modify_date") VALUES ('pgfouine-right-now-on-my-server', 'I''m running pgFouine right now on my server', NULL, false, '(pgFouine)[http://pgfouine.projects.postgresql.org/] is a ', '', '', '', '2012-04-19 18:15:20+01:00', 'markdown', 'PostgreSQL|pgFouine|log analyzer|analyzer', NULL, '', false, false, '2012-04-19 15:17:33.164914+00:00') RETURNING "plog_blogitem"."id";

0.60

0.6s

SELECT COUNT(*) FROM "words" WHERE (("words"."language" = 'en-us' OR "words"."language" = 'en-gb' ) AND "words"."definition" IS NULL);

0.48

0.5s

SELECT COUNT(*) FROM "words" WHERE ("words"."language" = 'fr' AND "words"."definition" IS NULL);

0.46

1.4s

SELECT "words"."id", "words"."word", "words"."language", "words"."length", "words"."part_of_speech", "words"."definition", "words"."name" FROM "words" WHERE (UPPER("words"."word"::text) LIKE UPPER('') AND UPPER("words"."word"::text) LIKE UPPER('') AND UPPER("words"."word"::text) LIKE UPPER('') AND "words"."length" = 0 AND "words"."language" = '' ) ORDER BY "words"."word" ASC LIMIT 0;

0.40

Day	Time	Count	Av. Duration
Apr 18	11pm	5	0.30
Apr 19	12am	1	0.62
	2am	1	1.87
	8am	1	0.10
	10am	1	0.37
	11am	3	0.08
	12pm	1	0.05
	3pm	1	0.93

5.7s

SELECT "words"."id", "words"."word", "words"."language", "words"."length", "words"."part_of_speech", "words"."definition", "words"."name" FROM "words" WHERE ("words"."length" = 0 AND UPPER("words"."word"::text) LIKE UPPER('') AND UPPER("words"."word"::text) LIKE UPPER('') AND "words"."language" = '' AND UPPER("words"."word"::text) LIKE UPPER('') ) ORDER BY "words"."word" ASC LIMIT 0;

0.40

1.2s

SELECT COUNT(*) FROM "words" WHERE (UPPER("words"."word"::text) LIKE UPPER('') AND UPPER("words"."word"::text) LIKE UPPER('') AND UPPER("words"."word"::text) LIKE UPPER('') AND "words"."length" = 0 AND "words"."language" = '' );

0.28

140

Day	Time	Count	Av. Duration
Apr 18	10pm	3	0.23
	11pm	14	0.17
Apr 19	12am	11	2.52
	1am	11	0.33
	2am	20	0.06
	3am	11	0.10
	4am	12	0.01
	5am	8	0.01
	6am	11	0.06
	7am	12	0.02
	10am	4	0.03
	12pm	7	0.06
	1pm	7	0.08
	2pm	8	0.04
	3pm	1	0.16

39.5s

SELECT COUNT(*) FROM "plog_blogitem" WHERE to_tsvector('',title) @@ to_tsquery('', '');

0.28

Day	Time	Count	Av. Duration
Apr 18	11pm	1	0.98
Apr 19	5am	1	0.15
	8am	3	0.06
	11am	4	0.45
	12pm	2	0.19
	1pm	1	0.08
	5pm	1	0.08

3.7s

SELECT "words"."id", "words"."word", "words"."language", "words"."length", "words"."part_of_speech", "words"."definition", "words"."name" FROM "words" WHERE ("words"."length" = 0 AND UPPER("words"."word"::text) LIKE UPPER('') AND "words"."language" = '' ) ORDER BY "words"."word" ASC LIMIT 0;

0.28

Day	Time	Count	Av. Duration
Apr 18	10pm	2	0.26
	11pm	5	0.12
Apr 19	12am	1	0.09
	1am	2	0.25
	7am	1	0.21
	11am	2	0.94
	1pm	1	0.10

3.9s

SELECT "words"."id", "words"."word", "words"."language", "words"."length", "words"."part_of_speech", "words"."definition", "words"."name" FROM "words" WHERE (UPPER("words"."word"::text) LIKE UPPER('') AND UPPER("words"."word"::text) LIKE UPPER('') AND "words"."length" = 0 AND "words"."language" = '' ) ORDER BY "words"."word" ASC LIMIT 0;

0.24

0.2s

SELECT COUNT(*) FROM "words" WHERE ("words"."language" = 'en-us' OR "words"."language" = 'en-gb' );