explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dHzj

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 9.273 ↓ 0.0 0 1

Hash Join (cost=11.00..3,818,031.59 rows=23,416 width=1,728) (actual time=9.273..9.273 rows=0 loops=1)

  • Hash Cond: (((replace(replace((regexp_matches((d.docentrysourcepatientid)::text, '(.*)\^\^\^.*'::text))::text, '{'::text, ''::text), '}'::text, ''::text)) = (i.mrn)::text) AND ((replace(replace((regexp_matches((d.docentrysourcepatientid)::text, '.*\^\^\^ (...)
  • Join Filter: ((d.docentrypatientid)::text <> (i.mpid)::text)
  • Buffers: shared read=1
2. 9.261 9.261 ↑ 23,415,633.0 1 1

Seq Scan on documententry d (cost=0.00..3,407,720.16 rows=23,415,633 width=156) (actual time=9.261..9.261 rows=1 loops=1)

  • Buffers: shared read=1
3. 0.001 0.001 ↓ 0.0 0 1

Hash (cost=10.40..10.40 rows=40 width=1,672) (actual time=0.001..0.001 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
4. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on tmpinus i (cost=0.00..10.40 rows=40 width=1,672) (actual time=0.000..0.000 rows=0 loops=1)

Planning time : 0.935 ms
Execution time : 9.343 ms