explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aNmq

Settings
# exclusive inclusive rows x rows loops node
1. 138.815 256.572 ↑ 1.0 13,835 1

Hash Right Join (cost=934.29..12,451.01 rows=13,835 width=42) (actual time=13.801..256.572 rows=13,835 loops=1)

  • Hash Cond: ((prvs_pr.patient_id)::text = (pd.previous_visit_id)::text)
2. 104.780 104.780 ↑ 1.0 122,659 1

Seq Scan on patient_registration prvs_pr (cost=0.00..5,459.59 rows=122,659 width=18) (actual time=0.283..104.780 rows=122,659 loops=1)

3. 6.714 12.977 ↑ 1.0 13,835 1

Hash (cost=625.35..625.35 rows=13,835 width=51) (actual time=12.977..12.977 rows=13,835 loops=1)

  • Buckets: 2,048 Batches: 2 Memory Usage: 644kB
4. 6.263 6.263 ↑ 1.0 13,835 1

Seq Scan on patient_details pd (cost=0.00..625.35 rows=13,835 width=51) (actual time=0.008..6.263 rows=13,835 loops=1)

Total runtime : 257.802 ms