explain.depesz.com

A tool for finding a real cause for slow queries.

Result: psu

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.829 260,517.755 ↑ 2.9 125 1

Sort (cost=156,453.48..156,454.37 rows=359 width=42) (actual time=260,517.643..260,517.755 rows=125 loops=1)

  • Sort Key: d.det_indexvalue
2. 16.022 260,516.926 ↑ 2.9 125 1

Nested Loop (cost=37,613.48..156,438.24 rows=359 width=42) (actual time=237,277.133..260,516.926 rows=125 loops=1)

3. 341.752 228,314.516 ↑ 1.5 2,301 1

Bitmap Heap Scan on img_pageevent e (cost=37,611.47..52,286.92 rows=3,462 width=20) (actual time=227,986.947..228,314.516 rows=2,301 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. 227,972.764 227,972.764 ↓ 1.4 7,190 1

Bitmap Index Scan on x_img_pageevent_hdr_intdocid_pev_date (cost=0.00..37,611.47 rows=5,234 width=0) (actual time=227,972.764..227,972.764 rows=7,190 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 32,186.388 ↓ 0.0 0 2,301

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=2,301)

  • Recheck Cond: (((d.hdr_intdocid)::text = ("outer".hdr_intdocid)::text) AND (d.det_sequence = 0))
  • Filter: ((ref_indexcode)::text = 'MBL'::text)
6. 31,549.011 31,549.011 ↑ 7.0 1 2,301

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=2,301)

  • Index Cond: (((d.hdr_intdocid)::text = ("outer".hdr_intdocid)::text) AND (d.det_sequence = 0))