pgFouine: PostgreSQL log analysis report

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

Overall statistics ^

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
1 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;
2 11m43s 0.99
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" = '' );
3 1m52s 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 (...);
4 1m27s 0.03
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" = '';
5 1m2s 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;
6 1m 7.52
SELECT COUNT(*) FROM "words" WHERE (UPPER("words"."word"::text) LIKE UPPER('') AND "words"."length" = 0 AND "words"."language" = '' );
7 56.6s 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;
8 46.9s 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))));
9 39.5s 0.28
SELECT COUNT(*) FROM "plog_blogitem" WHERE to_tsvector('',title) @@ to_tsquery('', '');
10 34.5s 0.04
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"."alias" = '';
11 34.0s 0.02
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" < '' OR ("plog_blogitem"."id" < 0 AND "plog_blogitem"."pub_date" = '' )) ORDER BY "plog_blogitem"."pub_date" DESC, "plog_blogitem"."id" DESC LIMIT 0;
12 28.7s 0.01
SET DATESTYLE TO '';
13 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;
14 22.3s 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" = '' );
15 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;
16 15.8s 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" = '' ));
17 15.0s 0.07
SELECT COUNT(*) FROM "searches" WHERE ("searches"."add_date" >= '' AND "searches"."language" = '' );
18 14.2s 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;
19 13.3s 0.09
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" < '' AND "plog_blogitem_categories"."category_id" = 0 ) ORDER BY "plog_blogitem"."pub_date" DESC LIMIT 0;
20 12.3s 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
1 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;
2 28.7s 0.01
SET DATESTYLE TO '';
3 12.3s 0.00
SHOW client_encoding;
4 0.2s 0.00
SHOW default_transaction_isolation;
5 1m27s 0.03
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" = '';
6 14.2s 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;
7 34.0s 0.02
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" < '' OR ("plog_blogitem"."id" < 0 AND "plog_blogitem"."pub_date" = '' )) ORDER BY "plog_blogitem"."pub_date" DESC, "plog_blogitem"."id" DESC LIMIT 0;
8 11.1s 0.01
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" < '' AND ("plog_blogitem"."pub_date" > '' OR ("plog_blogitem"."id" > 0 AND "plog_blogitem"."pub_date" = '' ))) ORDER BY "plog_blogitem"."pub_date" ASC, "plog_blogitem"."id" ASC LIMIT 0;
9 56.6s 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;
10 1m52s 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 (...);
11 0.8s 0.00
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" = 0;
12 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);
13 34.5s 0.04
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"."alias" = '';
14 5.4s 0.01
SET TIME ZONE '';
15 11m43s 0.99
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" = '' );
16 7.2s 0.01
SELECT COUNT(*) FROM "plog_blogcomment" WHERE ("plog_blogcomment"."blogitem_id" = 0 AND "plog_blogcomment"."approved" = true );
17 2.9s 0.01
SELECT "plog_category"."id", "plog_category"."name" FROM "plog_category" WHERE "plog_category"."name" IN (...);
18 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;
19 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" = '' );
20 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
1 212.39 21m14s
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;
2 7.52 1m
SELECT COUNT(*) FROM "words" WHERE (UPPER("words"."word"::text) LIKE UPPER('') AND "words"."length" = 0 AND "words"."language" = '' );
3 3.60 46.9s
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))));
4 1.63 3.3s
SELECT DISTINCT ON ("searches"."language") "searches"."language" FROM "searches" WHERE NOT ("searches"."search_word" IN (...));
5 1.59 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" = '' );
6 1.35 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;
7 1.16 2.3s
SELECT "searches"."id", "searches"."search_word", "searches"."add_date", "searches"."user_agent", "searches"."ip_address", "searches"."language", "searches"."search_type", "searches"."found_word_id" FROM "searches";
8 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;
9 0.99 11m43s
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" = '' );
10 0.88 1.8s
SELECT DISTINCT ON ("searches"."search_type") "searches"."search_type" FROM "searches" WHERE NOT ("searches"."search_word" IN (...));
11 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";
12 0.60 0.6s
SELECT COUNT(*) FROM "words" WHERE (("words"."language" = 'en-us' OR "words"."language" = 'en-gb' ) AND "words"."definition" IS NULL);
13 0.48 0.5s
SELECT COUNT(*) FROM "words" WHERE ("words"."language" = 'fr' AND "words"."definition" IS NULL);
14 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;
15 0.40 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;
16 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" = '' );
17 0.28 39.5s
SELECT COUNT(*) FROM "plog_blogitem" WHERE to_tsvector('',title) @@ to_tsquery('', '');
18 0.28 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;
19 0.28 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;
20 0.24 0.2s
SELECT COUNT(*) FROM "words" WHERE ("words"."language" = 'en-us' OR "words"."language" = 'en-gb' );
Table of contents