explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Bgv3

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

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

  • Buffers: shared hit=4 read=3
2. 0.001 0.209 ↑ 2.0 1 1

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

  • Buffers: shared hit=4 read=3
3. 0.008 0.208 ↑ 2.0 1 1

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

  • Sort Key: id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=4 read=3
4. 0.010 0.200 ↑ 2.0 1 1

Bitmap Heap Scan on archive d (cost=3.29..5.73 rows=2 width=8) (actual time=0.200..0.200 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=4 read=3
5. 0.072 0.190 ↓ 0.0 0 1

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

  • Buffers: shared hit=3 read=3
6. 0.110 0.110 ↓ 0.0 0 1

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

  • Index Cond: (((xpath('/metadata/accessCode/text()'::text, rip, '{}'::text[]))[1])::text = 'AC7G2X'::text)
  • Buffers: shared read=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