explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dVkB

Settings
# exclusive inclusive rows x rows loops node
1. 0.031 2.984 ↓ 20.0 20 1

Sort (cost=13.12..13.12 rows=1 width=4) (actual time=2.983..2.984 rows=20 loops=1)

  • Sort Key: (cdr8_trim_refnum(rip))
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=13 read=2
2. 2.953 2.953 ↓ 20.0 20 1

Index Scan using cdr8_office_notary_deed on archive (cost=0.28..13.11 rows=1 width=4) (actual time=0.454..2.953 rows=20 loops=1)

  • Index Cond: (((xpath('/metadata/office/text()'::text, rip, '{}'::text[]))[1])::text = 'N999817-1'::text)
  • Filter: ((((((xpath('/metadata/creationDate/text()'::text, rip, '{}'::text[]))[1])::text)::date >= '2010-01-01'::date) AND ((((xpath('/metadata/creationDate/text()'::text, rip, '{}'::text[]))[1])::text)::date <= '2019-02-22'::date)) OR ((((xpath('/metadata/notUsed/text()'::text, rip, '{}'::text[]))[1])::text)::boolean AND ((((xpath('/metadata/archivingTime/text()'::text, rip, '{}'::text[]))[1])::text)::date >= '2010-01-01'::date) AND ((((xpath('/metadata/archivingTime/text()'::text, rip, '{}'::text[]))[1])::text)::date <= '2019-02-22'::date)))
  • Buffers: shared hit=13 read=2