explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7Aej

Settings
# exclusive inclusive rows x rows loops node
1. 1.404 1.404 ↑ 284.8 5 1

CTE Scan on childgeoitemlist (cost=319.08..347.56 rows=1,424 width=64) (actual time=0.220..1.404 rows=5 loops=1)

  • Buffers: shared hit=33
2.          

CTE childgeoitemlist

3. 0.019 1.397 ↑ 284.8 5 1

Recursive Union (cost=0.00..319.08 rows=1,424 width=64) (actual time=0.218..1.397 rows=5 loops=1)

  • Buffers: shared hit=33
4. 0.270 0.270 ↓ 5.8 23 1

Seq Scan on user_patient_merge (cost=0.00..23.50 rows=4 width=64) (actual time=0.215..0.270 rows=23 loops=1)

  • Filter: (((patient_from_id)::character varying)::text = 'ca3b6bdc-aaba-4d2b-81f4-1cee3577368b'::text)
  • Rows Removed by Filter: 689
  • Buffers: shared hit=11
5. 0.768 1.108 ↑ 11.8 12 2

Hash Join (cost=1.30..26.71 rows=142 width=64) (actual time=0.454..0.554 rows=12 loops=2)

  • Hash Cond: (((r.patient_from_id)::character varying)::text = (t.patient_to_id)::text)
  • Buffers: shared hit=22
6. 0.332 0.332 ↑ 1.0 712 2

Seq Scan on user_patient_merge r (cost=0.00..18.12 rows=712 width=32) (actual time=0.001..0.166 rows=712 loops=2)

  • Buffers: shared hit=22
7. 0.006 0.008 ↑ 20.0 2 2

Hash (cost=0.80..0.80 rows=40 width=32) (actual time=0.004..0.004 rows=2 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
8. 0.002 0.002 ↑ 20.0 2 2

WorkTable Scan on childgeoitemlist t (cost=0.00..0.80 rows=40 width=32) (actual time=0.000..0.001 rows=2 loops=2)

Planning time : 0.139 ms