pgFouine: PostgreSQL log analysis report

Overall statistics | Queries by type | Slowest queries | Queries that took up the most time (N) | Most frequent queries (N) | Slowest queries (N)

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

Overall statistics ^

Queries by type ^

Type Count Percentage
SELECT 61 17.2
UPDATE 1 0.3

Slowest queries ^

Rank Duration (s) Query
1 10.18
SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '000=%') AND a.STATUS >= '16' AND a.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code IN ('page', 'page_multiple_page') OR type_code IN ('pdf_file', 'calendar_event_single', 'calendar_event_recurring', 'news_item', 'page_custom_form') ) INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('3527','7')) AND ( (p.permission = '1' AND ( (p.userid <> '7') OR (p.userid = '7' AND granted = '1') ) ) OR (p.permission > '1' AND p.granted = '1') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '0') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE 'house%') GROUP BY ai.assetid];
2 6.24
SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '000=%') AND a.STATUS >= '16' AND a.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code IN ('page', 'page_multiple_page') OR type_code IN ('pdf_file', 'calendar_event_single', 'calendar_event_recurring', 'news_item', 'page_custom_form') ) INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('3527','7')) AND ( (p.permission = '1' AND ( (p.userid <> '7') OR (p.userid = '7' AND granted = '1') ) ) OR (p.permission > '1' AND p.granted = '1') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '0') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE 'team%') GROUP BY ai.assetid];
3 6.23
SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '000=%') AND a.STATUS >= '16' AND a.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code IN ('page', 'page_multiple_page') OR type_code IN ('pdf_file', 'calendar_event_single', 'calendar_event_recurring', 'news_item', 'page_custom_form') ) INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('3527','7')) AND ( (p.permission = '1' AND ( (p.userid <> '7') OR (p.userid = '7' AND granted = '1') ) ) OR (p.permission > '1' AND p.granted = '1') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '0') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE 'lord%') GROUP BY ai.assetid];
4 6.06
SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '000=%') AND a.STATUS >= '16' AND a.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code IN ('page', 'page_multiple_page') OR type_code IN ('pdf_file', 'calendar_event_single', 'calendar_event_recurring', 'news_item', 'page_custom_form') ) INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('3527','7')) AND ( (p.permission = '1' AND ( (p.userid <> '7') OR (p.userid = '7' AND granted = '1') ) ) OR (p.permission > '1' AND p.granted = '1') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '0') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE 'copy%') GROUP BY ai.assetid];
5 5.92
SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '000=%') AND a.STATUS >= '16' AND a.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code IN ('page', 'page_multiple_page') OR type_code IN ('pdf_file', 'calendar_event_single', 'calendar_event_recurring', 'news_item', 'page_custom_form') ) INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('3527','7')) AND ( (p.permission = '1' AND ( (p.userid <> '7') OR (p.userid = '7' AND granted = '1') ) ) OR (p.permission > '1' AND p.granted = '1') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '0') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE 'plans%') GROUP BY ai.assetid];
6 5.10
SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '000=%') AND a.STATUS >= '16' AND a.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code IN ('page', 'page_multiple_page') OR type_code IN ('pdf_file', 'calendar_event_single', 'calendar_event_recurring', 'news_item', 'page_custom_form') ) INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('3527','7')) AND ( (p.permission = '1' AND ( (p.userid <> '7') OR (p.userid = '7' AND granted = '1') ) ) OR (p.permission > '1' AND p.granted = '1') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '0') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE 'zone%') GROUP BY ai.assetid];
7 5.01
SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '000=%') AND a.STATUS >= '16' AND a.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code IN ('page', 'page_multiple_page') OR type_code IN ('pdf_file', 'calendar_event_single', 'calendar_event_recurring', 'news_item', 'page_custom_form') ) INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('3527','7')) AND ( (p.permission = '1' AND ( (p.userid <> '7') OR (p.userid = '7' AND granted = '1') ) ) OR (p.permission > '1' AND p.granted = '1') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '0') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE 'fire%') GROUP BY ai.assetid];
8 4.88
SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '000=%') AND a.STATUS >= '16' AND a.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code IN ('page', 'page_multiple_page') OR type_code IN ('pdf_file', 'calendar_event_single', 'calendar_event_recurring', 'news_item', 'page_custom_form') ) INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('3527','7')) AND ( (p.permission = '1' AND ( (p.userid <> '7') OR (p.userid = '7' AND granted = '1') ) ) OR (p.permission > '1' AND p.granted = '1') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '0') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE 'construction%') GROUP BY ai.assetid];
9 4.21
SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '000=%') AND a.STATUS >= '16' AND a.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code IN ('page', 'page_multiple_page') OR type_code IN ('pdf_file', 'calendar_event_single', 'calendar_event_recurring', 'news_item', 'page_custom_form') ) INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('3527','7')) AND ( (p.permission = '1' AND ( (p.userid <> '7') OR (p.userid = '7' AND granted = '1') ) ) OR (p.permission > '1' AND p.granted = '1') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '0') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE 'english%') GROUP BY ai.assetid];
10 3.57
SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '000=%') AND a.STATUS >= '16' AND a.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code IN ('page', 'page_multiple_page') OR type_code IN ('pdf_file', 'calendar_event_single', 'calendar_event_recurring', 'news_item', 'page_custom_form') ) INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('3527','7')) AND ( (p.permission = '1' AND ( (p.userid <> '7') OR (p.userid = '7' AND granted = '1') ) ) OR (p.permission > '1' AND p.granted = '1') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '0') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE 'swimming%') GROUP BY ai.assetid];
11 2.89
SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '000=%') AND a.STATUS >= '16' AND a.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code IN ('page', 'page_multiple_page') OR type_code IN ('pdf_file', 'calendar_event_single', 'calendar_event_recurring', 'news_item', 'page_custom_form') ) INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('3527','7')) AND ( (p.permission = '1' AND ( (p.userid <> '7') OR (p.userid = '7' AND granted = '1') ) ) OR (p.permission > '1' AND p.granted = '1') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '0') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE 'executive%') GROUP BY ai.assetid];
12 2.54
SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '000=%') AND a.STATUS >= '16' AND a.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code IN ('page', 'page_multiple_page') OR type_code IN ('pdf_file', 'calendar_event_single', 'calendar_event_recurring', 'news_item', 'page_custom_form') ) INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('3527','7')) AND ( (p.permission = '1' AND ( (p.userid <> '7') OR (p.userid = '7' AND granted = '1') ) ) OR (p.permission > '1' AND p.granted = '1') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '0') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE 'william%') GROUP BY ai.assetid];
13 2.47
SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '000=%') AND a.STATUS >= '16' AND a.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code IN ('page', 'page_multiple_page') OR type_code IN ('pdf_file', 'calendar_event_single', 'calendar_event_recurring', 'news_item', 'page_custom_form') ) INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('3527','7')) AND ( (p.permission = '1' AND ( (p.userid <> '7') OR (p.userid = '7' AND granted = '1') ) ) OR (p.permission > '1' AND p.granted = '1') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '0') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE 'tenders%') GROUP BY ai.assetid];
14 2.13
SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '000=%') AND a.STATUS >= '16' AND a.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code IN ('page', 'page_multiple_page') OR type_code IN ('pdf_file', 'calendar_event_single', 'calendar_event_recurring', 'news_item', 'page_custom_form') ) INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('3527','7')) AND ( (p.permission = '1' AND ( (p.userid <> '7') OR (p.userid = '7' AND granted = '1') ) ) OR (p.permission > '1' AND p.granted = '1') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '0') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE 'land%') GROUP BY ai.assetid];
15 2.07
SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '000=%') AND a.STATUS >= '16' AND a.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code IN ('page', 'page_multiple_page') OR type_code IN ('pdf_file', 'calendar_event_single', 'calendar_event_recurring', 'news_item', 'page_custom_form') ) INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('3527','7')) AND ( (p.permission = '1' AND ( (p.userid <> '7') OR (p.userid = '7' AND granted = '1') ) ) OR (p.permission > '1' AND p.granted = '1') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '0') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE 'classes%') GROUP BY ai.assetid];
16 1.95
SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '000=%') AND a.STATUS >= '16' AND a.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code IN ('page', 'page_multiple_page') OR type_code IN ('pdf_file', 'calendar_event_single', 'calendar_event_recurring', 'news_item', 'page_custom_form') ) INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('3527','7')) AND ( (p.permission = '1' AND ( (p.userid <> '7') OR (p.userid = '7' AND granted = '1') ) ) OR (p.permission > '1' AND p.granted = '1') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '0') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE 'teacher%') GROUP BY ai.assetid];
17 1.93
SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '000=%') AND a.STATUS >= '16' AND a.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code IN ('page', 'page_multiple_page') OR type_code IN ('pdf_file', 'calendar_event_single', 'calendar_event_recurring', 'news_item', 'page_custom_form') ) INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('3527','7')) AND ( (p.permission = '1' AND ( (p.userid <> '7') OR (p.userid = '7' AND granted = '1') ) ) OR (p.permission > '1' AND p.granted = '1') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '0') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE 'childhood%') GROUP BY ai.assetid];
18 1.61
(SELECT DISTINCT(ll.majorid), ll.type_code, ll.treeid, length(ll.treeid)/SELECT DISTINCT(ll.majorid) AS depth FROM ( SELECT l.majorid, t.treeid, a.type_code, a.name FROM sq_ast_lnk_tree t INNER JOIN sq_ast_lnk l ON t.linkid = l.linkid INNER JOIN sq_ast a ON l.majorid = a.assetid, (SELECT sq_get_parent_treeids AS treeid FROM sq_get_parent_treeids(ll.type_code, ll.treeid)) tree_linkids WHERE t.treeid=tree_linkids.treeid) ll UNION ALL SELECT sl.majorid, NULL, NULL AS treeid, NULL AS depth FROM sq_shdw_ast_lnk sl WHERE sl.minorid = $4 )ORDER BY depth DESC];
19 1.61
(SELECT DISTINCT(ll.majorid), ll.type_code, ll.treeid, length(ll.treeid)/SELECT DISTINCT(ll.majorid) AS depth FROM ( SELECT l.majorid, t.treeid, a.type_code, a.name FROM sq_ast_lnk_tree t INNER JOIN sq_ast_lnk l ON t.linkid = l.linkid INNER JOIN sq_ast a ON l.majorid = a.assetid, (SELECT sq_get_parent_treeids AS treeid FROM sq_get_parent_treeids(ll.type_code, ll.treeid)) tree_linkids WHERE t.treeid=tree_linkids.treeid) ll UNION ALL SELECT sl.majorid, NULL, NULL AS treeid, NULL AS depth FROM sq_shdw_ast_lnk sl WHERE sl.minorid = $4 )ORDER BY depth DESC];
20 1.45
(SELECT DISTINCT(ll.majorid), ll.type_code, ll.treeid, length(ll.treeid)/SELECT DISTINCT(ll.majorid) AS depth FROM ( SELECT l.majorid, t.treeid, a.type_code, a.name FROM sq_ast_lnk_tree t INNER JOIN sq_ast_lnk l ON t.linkid = l.linkid INNER JOIN sq_ast a ON l.majorid = a.assetid, (SELECT sq_get_parent_treeids AS treeid FROM sq_get_parent_treeids(ll.type_code, ll.treeid)) tree_linkids WHERE t.treeid=tree_linkids.treeid) ll UNION ALL SELECT sl.majorid, NULL, NULL AS treeid, NULL AS depth FROM sq_shdw_ast_lnk sl WHERE sl.minorid = $4 )ORDER BY depth DESC];

Queries that took up the most time (N) ^

Rank Total duration Times executed Av. duration (s) Query
1 3m
292
Day Time Count Av. Duration
Oct 16 11am 141 0.65
  12pm 151 0.59
0.62
(SELECT DISTINCT(ll.majorid), ll.type_code, ll.treeid, length(ll.treeid)/SELECT DISTINCT(ll.majorid) AS depth FROM ( SELECT l.majorid, t.treeid, a.type_code, a.name FROM sq_ast_lnk_tree t INNER JOIN sq_ast_lnk l ON t.linkid = l.linkid INNER JOIN sq_ast a ON l.majorid = a.assetid, (SELECT sq_get_parent_treeids AS treeid FROM sq_get_parent_treeids(ll.type_code, ll.treeid)) tree_linkids WHERE t.treeid=tree_linkids.treeid) ll UNION ALL SELECT sl.majorid, NULL, NULL AS treeid, NULL AS depth FROM sq_shdw_ast_lnk sl WHERE sl.minorid = $4 )ORDER BY depth DESC];
2 1m27s
31
Day Time Count Av. Duration
Oct 16 11am 15 3.54
  12pm 16 2.17
2.83
SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '') AND a.STATUS >= '' AND a.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code IN ('', '') OR type_code IN ('', '', '', '', '') ) INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('','')) AND ( (p.permission = '' AND ( (p.userid <> '') OR (p.userid = '' AND granted = '') ) ) OR (p.permission > '' AND p.granted = '') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE '') GROUP BY ai.assetid];
3 16.5s
21
Day Time Count Av. Duration
Oct 16 11am 11 0.74
  12pm 10 0.84
0.79
SELECT l.majorid, l.minorid, l.linkid, l.value, l.link_type, l.type_code AS minor_type_code, l.sort_order, l.is_dependant, l.is_exclusive FROM sq_vw_ast_lnk_minor l WHERE l.majorid IN ($1) AND (l.link_type & $2) > 0 ORDER BY l.sort_order, l.type_code];
4 3.1s
4
Day Time Count Av. Duration
Oct 16 11am 3 0.78
  12pm 1 0.75
0.77
SELECT l.assetid, l.url, CASE WHEN l.http = '' THEN '' ELSE '' END AS protocol, ( (CASE WHEN l.http = '' THEN 0 ELSE 0 END) + (CASE WHEN SUBSTR(l.url || '', 0, 0) = '' THEN 0 ELSE 0 END) + (CASE WHEN SUBSTR(l.url || '', 0, 0) = '' THEN 0 ELSE 0 END) ) AS weighting FROM sq_ast_lookup l WHERE l.assetid IN ('', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '') ORDER BY weighting DESC, LENGTH(l.url) ASC];
5 1.7s
3
Day Time Count Av. Duration
Oct 16 11am 3 0.56
0.56
SELECT atr.name, atr.attrid, atr.type, COALESCE(v.custom_val, atr.default_val) AS value FROM sq_ast_attr atr LEFT OUTER JOIN sq_ast_attr_val v ON (atr.attrid = v.attrid AND v.assetid = $1) WHERE atr.type_code = $2];
6 0.9s
1
Day Time Count Av. Duration
Oct 16 11am 1 0.91
0.91
SELECT l.majorid, l.minorid, l.linkid, l.value, l.link_type, l.type_code AS minor_type_code, l.sort_order, l.is_dependant, l.is_exclusive FROM sq_vw_ast_lnk_minor l WHERE l.majorid IN ($1) AND (l.link_type & $2) > 0 AND l.is_exclusive = $3 AND l.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code = $4 ) ORDER BY l.sort_order, l.type_code];
7 0.6s
1
Day Time Count Av. Duration
Oct 16 11am 1 0.62
0.62
SELECT l.assetid, l.short_name, l.name, l.type_code, l.STATUS, l.linkid, l.link_type, l.sort_order, ap.path, u.url, (CASE u.http WHEN '1' THEN $1 WHEN '0' THEN $2 END) AS protocol, p.permission AS accessible FROM sq_vw_ast_lnk_minor l LEFT JOIN (SELECT p.assetid, p.permission FROM sq_vw_ast_lnk_minor l2 INNER JOIN sq_ast_perm p ON l2.assetid = p.assetid WHERE l2.majorid = $3 AND (( (p.permission = $4 AND ( p.userid <> $5 OR (p.userid = $6 AND p.granted = '1') ) ) OR ( p.permission > $7 AND p.granted = '1' ) ) AND (p.userid IN ('13568','7','30394'))) GROUP BY p.assetid, p.permission HAVING MIN(p.granted) <> '0') p ON (l.assetid = p.assetid) LEFT JOIN sq_ast_url u ON l.assetid = u.assetid LEFT JOIN sq_ast_path ap ON l.assetid = ap.assetid WHERE l.majorid = $8 AND l.link_type <= $9 ORDER BY sort_order];
8 0.6s
1
Day Time Count Av. Duration
Oct 16 12pm 1 0.59
0.59
UPDATE sq_ast_lnk SET sort_order = sort_order - 1 WHERE majorid = $1 AND sort_order > $2];

Most frequent queries (N) ^

Rank Times executed Total duration Av. duration (s) Query
1
292
Day Time Count Av. Duration
Oct 16 11am 141 0.65
  12pm 151 0.59
3m 0.62
(SELECT DISTINCT(ll.majorid), ll.type_code, ll.treeid, length(ll.treeid)/SELECT DISTINCT(ll.majorid) AS depth FROM ( SELECT l.majorid, t.treeid, a.type_code, a.name FROM sq_ast_lnk_tree t INNER JOIN sq_ast_lnk l ON t.linkid = l.linkid INNER JOIN sq_ast a ON l.majorid = a.assetid, (SELECT sq_get_parent_treeids AS treeid FROM sq_get_parent_treeids(ll.type_code, ll.treeid)) tree_linkids WHERE t.treeid=tree_linkids.treeid) ll UNION ALL SELECT sl.majorid, NULL, NULL AS treeid, NULL AS depth FROM sq_shdw_ast_lnk sl WHERE sl.minorid = $4 )ORDER BY depth DESC];
2
31
Day Time Count Av. Duration
Oct 16 11am 15 3.54
  12pm 16 2.17
1m27s 2.83
SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '') AND a.STATUS >= '' AND a.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code IN ('', '') OR type_code IN ('', '', '', '', '') ) INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('','')) AND ( (p.permission = '' AND ( (p.userid <> '') OR (p.userid = '' AND granted = '') ) ) OR (p.permission > '' AND p.granted = '') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE '') GROUP BY ai.assetid];
3
21
Day Time Count Av. Duration
Oct 16 11am 11 0.74
  12pm 10 0.84
16.5s 0.79
SELECT l.majorid, l.minorid, l.linkid, l.value, l.link_type, l.type_code AS minor_type_code, l.sort_order, l.is_dependant, l.is_exclusive FROM sq_vw_ast_lnk_minor l WHERE l.majorid IN ($1) AND (l.link_type & $2) > 0 ORDER BY l.sort_order, l.type_code];
4
4
Day Time Count Av. Duration
Oct 16 11am 3 0.78
  12pm 1 0.75
3.1s 0.77
SELECT l.assetid, l.url, CASE WHEN l.http = '' THEN '' ELSE '' END AS protocol, ( (CASE WHEN l.http = '' THEN 0 ELSE 0 END) + (CASE WHEN SUBSTR(l.url || '', 0, 0) = '' THEN 0 ELSE 0 END) + (CASE WHEN SUBSTR(l.url || '', 0, 0) = '' THEN 0 ELSE 0 END) ) AS weighting FROM sq_ast_lookup l WHERE l.assetid IN ('', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '') ORDER BY weighting DESC, LENGTH(l.url) ASC];
5
3
Day Time Count Av. Duration
Oct 16 11am 3 0.56
1.7s 0.56
SELECT atr.name, atr.attrid, atr.type, COALESCE(v.custom_val, atr.default_val) AS value FROM sq_ast_attr atr LEFT OUTER JOIN sq_ast_attr_val v ON (atr.attrid = v.attrid AND v.assetid = $1) WHERE atr.type_code = $2];
6
1
Day Time Count Av. Duration
Oct 16 11am 1 0.91
0.9s 0.91
SELECT l.majorid, l.minorid, l.linkid, l.value, l.link_type, l.type_code AS minor_type_code, l.sort_order, l.is_dependant, l.is_exclusive FROM sq_vw_ast_lnk_minor l WHERE l.majorid IN ($1) AND (l.link_type & $2) > 0 AND l.is_exclusive = $3 AND l.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code = $4 ) ORDER BY l.sort_order, l.type_code];
7
1
Day Time Count Av. Duration
Oct 16 11am 1 0.62
0.6s 0.62
SELECT l.assetid, l.short_name, l.name, l.type_code, l.STATUS, l.linkid, l.link_type, l.sort_order, ap.path, u.url, (CASE u.http WHEN '1' THEN $1 WHEN '0' THEN $2 END) AS protocol, p.permission AS accessible FROM sq_vw_ast_lnk_minor l LEFT JOIN (SELECT p.assetid, p.permission FROM sq_vw_ast_lnk_minor l2 INNER JOIN sq_ast_perm p ON l2.assetid = p.assetid WHERE l2.majorid = $3 AND (( (p.permission = $4 AND ( p.userid <> $5 OR (p.userid = $6 AND p.granted = '1') ) ) OR ( p.permission > $7 AND p.granted = '1' ) ) AND (p.userid IN ('13568','7','30394'))) GROUP BY p.assetid, p.permission HAVING MIN(p.granted) <> '0') p ON (l.assetid = p.assetid) LEFT JOIN sq_ast_url u ON l.assetid = u.assetid LEFT JOIN sq_ast_path ap ON l.assetid = ap.assetid WHERE l.majorid = $8 AND l.link_type <= $9 ORDER BY sort_order];
8
1
Day Time Count Av. Duration
Oct 16 12pm 1 0.59
0.6s 0.59
UPDATE sq_ast_lnk SET sort_order = sort_order - 1 WHERE majorid = $1 AND sort_order > $2];

Slowest queries (N) ^

Rank Av. duration (s) Times executed Total duration Query
1 2.83
31
Day Time Count Av. Duration
Oct 16 11am 15 3.54
  12pm 16 2.17
1m27s
SELECT ai.assetid, SUM(ai.score) AS search_score FROM sq_sch_idx ai, (SELECT a.assetid FROM sq_ast a INNER JOIN sq_ast_lnk l ON l.minorid = a.assetid INNER JOIN sq_ast_lnk_tree t ON t.linkid = l.linkid WHERE (t.treeid LIKE '') AND a.STATUS >= '' AND a.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code IN ('', '') OR type_code IN ('', '', '', '', '') ) INTERSECT ALL SELECT p.assetid FROM sq_ast_perm p WHERE ( p.userid IN ('','')) AND ( (p.permission = '' AND ( (p.userid <> '') OR (p.userid = '' AND granted = '') ) ) OR (p.permission > '' AND p.granted = '') ) GROUP BY p.assetid HAVING MIN(p.granted) <> '') asset_check WHERE (ai.assetid=asset_check.assetid) AND (ai.value LIKE '') GROUP BY ai.assetid];
2 0.91
1
Day Time Count Av. Duration
Oct 16 11am 1 0.91
0.9s
SELECT l.majorid, l.minorid, l.linkid, l.value, l.link_type, l.type_code AS minor_type_code, l.sort_order, l.is_dependant, l.is_exclusive FROM sq_vw_ast_lnk_minor l WHERE l.majorid IN ($1) AND (l.link_type & $2) > 0 AND l.is_exclusive = $3 AND l.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code = $4 ) ORDER BY l.sort_order, l.type_code];
3 0.79
21
Day Time Count Av. Duration
Oct 16 11am 11 0.74
  12pm 10 0.84
16.5s
SELECT l.majorid, l.minorid, l.linkid, l.value, l.link_type, l.type_code AS minor_type_code, l.sort_order, l.is_dependant, l.is_exclusive FROM sq_vw_ast_lnk_minor l WHERE l.majorid IN ($1) AND (l.link_type & $2) > 0 ORDER BY l.sort_order, l.type_code];
4 0.77
4
Day Time Count Av. Duration
Oct 16 11am 3 0.78
  12pm 1 0.75
3.1s
SELECT l.assetid, l.url, CASE WHEN l.http = '' THEN '' ELSE '' END AS protocol, ( (CASE WHEN l.http = '' THEN 0 ELSE 0 END) + (CASE WHEN SUBSTR(l.url || '', 0, 0) = '' THEN 0 ELSE 0 END) + (CASE WHEN SUBSTR(l.url || '', 0, 0) = '' THEN 0 ELSE 0 END) ) AS weighting FROM sq_ast_lookup l WHERE l.assetid IN ('', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '') ORDER BY weighting DESC, LENGTH(l.url) ASC];
5 0.62
1
Day Time Count Av. Duration
Oct 16 11am 1 0.62
0.6s
SELECT l.assetid, l.short_name, l.name, l.type_code, l.STATUS, l.linkid, l.link_type, l.sort_order, ap.path, u.url, (CASE u.http WHEN '1' THEN $1 WHEN '0' THEN $2 END) AS protocol, p.permission AS accessible FROM sq_vw_ast_lnk_minor l LEFT JOIN (SELECT p.assetid, p.permission FROM sq_vw_ast_lnk_minor l2 INNER JOIN sq_ast_perm p ON l2.assetid = p.assetid WHERE l2.majorid = $3 AND (( (p.permission = $4 AND ( p.userid <> $5 OR (p.userid = $6 AND p.granted = '1') ) ) OR ( p.permission > $7 AND p.granted = '1' ) ) AND (p.userid IN ('13568','7','30394'))) GROUP BY p.assetid, p.permission HAVING MIN(p.granted) <> '0') p ON (l.assetid = p.assetid) LEFT JOIN sq_ast_url u ON l.assetid = u.assetid LEFT JOIN sq_ast_path ap ON l.assetid = ap.assetid WHERE l.majorid = $8 AND l.link_type <= $9 ORDER BY sort_order];
6 0.62
292
Day Time Count Av. Duration
Oct 16 11am 141 0.65
  12pm 151 0.59
3m
(SELECT DISTINCT(ll.majorid), ll.type_code, ll.treeid, length(ll.treeid)/SELECT DISTINCT(ll.majorid) AS depth FROM ( SELECT l.majorid, t.treeid, a.type_code, a.name FROM sq_ast_lnk_tree t INNER JOIN sq_ast_lnk l ON t.linkid = l.linkid INNER JOIN sq_ast a ON l.majorid = a.assetid, (SELECT sq_get_parent_treeids AS treeid FROM sq_get_parent_treeids(ll.type_code, ll.treeid)) tree_linkids WHERE t.treeid=tree_linkids.treeid) ll UNION ALL SELECT sl.majorid, NULL, NULL AS treeid, NULL AS depth FROM sq_shdw_ast_lnk sl WHERE sl.minorid = $4 )ORDER BY depth DESC];
7 0.59
1
Day Time Count Av. Duration
Oct 16 12pm 1 0.59
0.6s
UPDATE sq_ast_lnk SET sort_order = sort_order - 1 WHERE majorid = $1 AND sort_order > $2];
8 0.56
3
Day Time Count Av. Duration
Oct 16 11am 3 0.56
1.7s
SELECT atr.name, atr.attrid, atr.type, COALESCE(v.custom_val, atr.default_val) AS value FROM sq_ast_attr atr LEFT OUTER JOIN sq_ast_attr_val v ON (atr.attrid = v.attrid AND v.assetid = $1) WHERE atr.type_code = $2];
Report generated by pgFouine 1.0. pgFouine is free software.
Table of contents