#	exclusive	inclusive	rows x	rows	loops	node
1.	0.829	260517.755	↑ 2.9	125	1	→ Sort (cost=156453.48..156454.37 rows=359 width=42) (actual time=260517.643..260517.755 rows=125 loops=1) Sort Key: d.det_indexvalue
2.	16.022	260516.926	↑ 2.9	125	1	→ Nested Loop (cost=37613.48..156438.24 rows=359 width=42) (actual time=237277.133..260516.926 rows=125 loops=1)
3.	341.752	228314.516	↑ 1.5	2301	1	→ Bitmap Heap Scan on img_pageevent e (cost=37611.47..52286.92 rows=3462 width=20) (actual time=227986.947..228314.516 rows=2301 loops=1) Recheck Cond: ((pev_date >= '2012-04-10 00:00:00'::timestamp without time zone) AND (pev_date <= '2012-04-10 23:59:59.9999'::timestamp without time zone)) Filter: ((ety_code)::text = 'STORE'::text)
4.	227972.764	227972.764	↓ 1.4	7190	1	→ Bitmap Index Scan on x_img_pageevent_hdr_intdocid_pev_date (cost=0.00..37611.47 rows=5234 width=0) (actual time=227972.764..227972.764 rows=7190 loops=1) Index Cond: ((pev_date >= '2012-04-10 00:00:00'::timestamp without time zone) AND (pev_date <= '2012-04-10 23:59:59.9999'::timestamp without time zone))
5.	637.377	32186.388	↓ 0.0	0	2301	→ Bitmap Heap Scan on img_pageindex d (cost=2.01..30.00 rows=7 width=34) (actual time=13.988..13.988 rows=0 loops=2301) Recheck Cond: (((d.hdr_intdocid)::text = ("outer".hdr_intdocid)::text) AND (d.det_sequence = 0)) Filter: ((ref_indexcode)::text = 'MBL'::text)
6.	31549.011	31549.011	↑ 7.0	1	2301	→ Bitmap Index Scan on img_pageindex_pkey (cost=0.00..2.01 rows=7 width=0) (actual time=13.711..13.711 rows=1 loops=2301) Index Cond: (((d.hdr_intdocid)::text = ("outer".hdr_intdocid)::text) AND (d.det_sequence = 0))

 Sort  (cost=156453.48..156454.37 rows=359 width=42) (actual time=260517.643..260517.755 rows=125 loops=1)
   Sort Key: d.det_indexvalue
   ->  Nested Loop  (cost=37613.48..156438.24 rows=359 width=42) (actual time=237277.133..260516.926 rows=125 loops=1)
         ->  Bitmap Heap Scan on img_pageevent e  (cost=37611.47..52286.92 rows=3462 width=20) (actual time=227986.947..228314.516 rows=2301 loops=1)
               Recheck Cond: ((pev_date >= '2012-04-10 00:00:00'::timestamp without time zone) AND (pev_date <= '2012-04-10 23:59:59.9999'::timestamp without time zone))
               Filter: ((ety_code)::text = 'STORE'::text)
               ->  Bitmap Index Scan on x_img_pageevent_hdr_intdocid_pev_date  (cost=0.00..37611.47 rows=5234 width=0) (actual time=227972.764..227972.764 rows=7190 loops=1)
                     Index Cond: ((pev_date >= '2012-04-10 00:00:00'::timestamp without time zone) AND (pev_date <= '2012-04-10 23:59:59.9999'::timestamp without time zone))
         ->  Bitmap Heap Scan on img_pageindex d  (cost=2.01..30.00 rows=7 width=34) (actual time=13.988..13.988 rows=0 loops=2301)
               Recheck Cond: (((d.hdr_intdocid)::text = ("outer".hdr_intdocid)::text) AND (d.det_sequence = 0))
               Filter: ((ref_indexcode)::text = 'MBL'::text)
               ->  Bitmap Index Scan on img_pageindex_pkey  (cost=0.00..2.01 rows=7 width=0) (actual time=13.711..13.711 rows=1 loops=2301)
                     Index Cond: (((d.hdr_intdocid)::text = ("outer".hdr_intdocid)::text) AND (d.det_sequence = 0))
 Total runtime: 260517.985 ms
(14 rows)

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	2	979.129 ms	0.4 %
Bitmap Index Scan	2	259521.775 ms	99.6 %
Nested Loop	1	16.022 ms	0.0 %
Sort	1	0.829 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
img_pageevent	1	341.752 ms	0.1 %
Bitmap Heap Scan	1	341.752 ms	100.0 %
img_pageindex	1	637.377 ms	0.2 %
Bitmap Heap Scan	1	637.377 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: psu

Colorize:

Columns visibility:

Per node type stats

Per table stats