explain.depesz.com

PostgreSQL's explain analyze made readable

Result: C86S

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.031 ↑ 2.0 1 1

Limit (cost=5.42..5.43 rows=2 width=8) (actual time=0.030..0.031 rows=1 loops=1)

  • Buffers: shared hit=5
2. 0.001 0.030 ↑ 2.0 1 1

Unique (cost=5.42..5.43 rows=2 width=8) (actual time=0.029..0.030 rows=1 loops=1)

  • Buffers: shared hit=5
3. 0.005 0.029 ↑ 2.0 1 1

Sort (cost=5.42..5.43 rows=2 width=8) (actual time=0.029..0.029 rows=1 loops=1)

  • Sort Key: id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=5
4. 0.004 0.024 ↑ 2.0 1 1

Bitmap Heap Scan on archive d (cost=2.99..5.41 rows=2 width=8) (actual time=0.024..0.024 rows=1 loops=1)

  • Recheck Cond: ((((xpath('/metadata/accessCode/text()'::text, rip, '{}'::text[]))[1])::text = '00043M'::text) OR (((xpath('/metadata/accessCode/text()'::text, rip, '{}'::text[]))[1])::text = '00043MNRegTest0G'::text))
  • Heap Blocks: exact=1
  • Buffers: shared hit=5
5. 0.000 0.020 ↓ 0.0 0 1

BitmapOr (cost=2.99..2.99 rows=2 width=0) (actual time=0.020..0.020 rows=0 loops=1)

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

Bitmap Index Scan on cdr8_accesscode (cost=0.00..1.49 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 = '00043M'::text)
  • Buffers: shared hit=2
7. 0.005 0.005 ↓ 0.0 0 1

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

  • Index Cond: (((xpath('/metadata/accessCode/text()'::text, rip, '{}'::text[]))[1])::text = '00043MNRegTest0G'::text)
  • Buffers: shared hit=2
Planning time : 0.317 ms