explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fVBW

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

Limit (cost=5.74..5.75 rows=2 width=8) (actual time=0.041..0.041 rows=1 loops=1)

  • Buffers: shared hit=7
2. 0.000 0.040 ↑ 2.0 1 1

Unique (cost=5.74..5.75 rows=2 width=8) (actual time=0.040..0.040 rows=1 loops=1)

  • Buffers: shared hit=7
3. 0.006 0.040 ↑ 2.0 1 1

Sort (cost=5.74..5.74 rows=2 width=8) (actual time=0.040..0.040 rows=1 loops=1)

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

Bitmap Heap Scan on archive d (cost=3.29..5.73 rows=2 width=8) (actual time=0.034..0.034 rows=1 loops=1)

  • Recheck Cond: ((((xpath('/metadata/accessCode/text()'::text, rip, '{}'::text[]))[1])::text = 'AC7G2X'::text) OR (((xpath('/metadata/accessCode/text()'::text, rip, '{}'::text[]))[1])::text = 'AC7G2XA1000131G'::text))
  • Heap Blocks: exact=1
  • Buffers: shared hit=7
5. 0.001 0.030 ↓ 0.0 0 1

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

  • Buffers: shared hit=6
6. 0.021 0.021 ↓ 0.0 0 1

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

  • Index Cond: (((xpath('/metadata/accessCode/text()'::text, rip, '{}'::text[]))[1])::text = 'AC7G2X'::text)
  • Buffers: shared hit=3
7. 0.008 0.008 ↑ 1.0 1 1

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

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