explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5FMm

Settings
# exclusive inclusive rows x rows loops node
1. 0.757 147,858.322 ↑ 1.7 43 1

Nested Loop (cost=40,373.63..881,125.31 rows=71 width=13) (actual time=6,126.812..147,858.322 rows=43 loops=1)

2. 75,011.326 147,854.297 ↓ 1.7 43 1

Nested Loop (cost=40,367.47..880,652.65 rows=26 width=13) (actual time=6,126.651..147,854.297 rows=43 loops=1)

  • Join Filter: ((((w.hdr_intdocid)::text = (h.hdr_intdocid)::text) AND (h.hdr_expires_on IS NULL)) OR (h.hdr_expires_on > now()))
3. 0.670 0.670 ↓ 1.8 43 1

Index Scan using img_workqueue_pkey on img_workqueue w (cost=0.00..52.80 rows=24 width=13) (actual time=0.056..0.670 rows=43 loops=1)

  • Index Cond: ((wkq_queuename)::text = '&4'::text)
4. 71,028.147 72,842.301 ↑ 1.0 1,065,043 43

Materialize (cost=40,367.47..56,738.90 rows=1,065,043 width=17) (actual time=0.011..1,694.007 rows=1,065,043 loops=43)

5. 1,814.154 1,814.154 ↑ 1.0 1,065,043 1

Seq Scan on img_page h (cost=0.00..33,581.43 rows=1,065,043 width=17) (actual time=0.072..1,814.154 rows=1,065,043 loops=1)

6. 0.516 3.268 ↑ 3.0 1 43

Bitmap Heap Scan on img_pageindex p (cost=6.16..18.14 rows=3 width=9) (actual time=0.074..0.076 rows=1 loops=43)

  • Recheck Cond: (((p.hdr_intdocid)::text = (w.hdr_intdocid)::text) AND (p.det_sequence = 0))
7. 2.752 2.752 ↑ 3.0 1 43

Bitmap Index Scan on img_pageindex_pkey (cost=0.00..6.16 rows=3 width=0) (actual time=0.064..0.064 rows=1 loops=43)

  • Index Cond: (((p.hdr_intdocid)::text = (w.hdr_intdocid)::text) AND (p.det_sequence = 0))
Total runtime : 147,862.010 ms