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 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))