explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9zCz

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.185 ↑ 1.0 1 1

Limit (cost=5.76..5.77 rows=1 width=8) (actual time=0.185..0.185 rows=1 loops=1)

  • Buffers: shared hit=7
2. 0.000 0.184 ↑ 1.0 1 1

Unique (cost=5.76..5.77 rows=1 width=8) (actual time=0.184..0.184 rows=1 loops=1)

  • Buffers: shared hit=7
3. 0.009 0.184 ↑ 1.0 1 1

Sort (cost=5.76..5.77 rows=1 width=8) (actual time=0.184..0.184 rows=1 loops=1)

  • Sort Key: id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=7
4. 0.154 0.175 ↑ 1.0 1 1

Bitmap Heap Scan on archive d (cost=3.29..5.75 rows=1 width=8) (actual time=0.175..0.175 rows=1 loops=1)

  • Recheck Cond: ((((xpath('/metadata/accessCode/text()'::text, rip, '{}'::text[]))[1])::text = '0000X7'::text) OR (((xpath('/metadata/accessCode/text()'::text, rip, '{}'::text[]))[1])::text = '0000X7N9999061G'::text))
  • Filter: (((((xpath('/metadata/area/text()'::text, rip, '{}'::text[]))[1])::text = 'gog-deed'::text) AND (COALESCE(((xpath('/metadata/creationOffice/text()'::text, rip, '{}'::text[]))[1])::text, ((xpath('/metadata/office/text()'::text, rip, '{}'::text[]))[1])::text) = 'N999906-1'::text) AND (((xpath('/metadata/accessCode/text()'::text, rip, '{}'::text[]))[1])::text = '0000X7'::text)) OR (((xpath('/metadata/accessCode/text()'::text, rip, '{}'::text[]))[1])::text = '0000X7N9999061G'::text))
  • Heap Blocks: exact=1
  • Buffers: shared hit=7
5. 0.001 0.021 ↓ 0.0 0 1

BitmapOr (cost=3.29..3.29 rows=2 width=0) (actual time=0.021..0.021 rows=0 loops=1)

  • Buffers: shared hit=6
6. 0.015 0.015 ↑ 1.0 1 1

Bitmap Index Scan on cdr8_accesscode (cost=0.00..1.64 rows=1 width=0) (actual time=0.015..0.015 rows=1 loops=1)

  • Index Cond: (((xpath('/metadata/accessCode/text()'::text, rip, '{}'::text[]))[1])::text = '0000X7'::text)
  • Buffers: shared hit=3
7. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on cdr8_accesscode (cost=0.00..1.64 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (((xpath('/metadata/accessCode/text()'::text, rip, '{}'::text[]))[1])::text = '0000X7N9999061G'::text)
  • Buffers: shared hit=3