explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oP5J

Settings
# exclusive inclusive rows x rows loops node
1. 1,585.693 3,201.076 ↑ 1.0 3,515,831 1

Hash Join (cost=20,758.46..388,528.57 rows=3,515,837 width=8) (actual time=193.013..3,201.076 rows=3,515,831 loops=1)

  • Hash Cond: (ppd.patientid = p.patient_id)
2. 1,422.495 1,422.495 ↑ 1.0 3,515,837 1

Seq Scan on mat_patientprescriptiondata ppd (cost=0.00..297,453.37 rows=3,515,837 width=8) (actual time=0.005..1,422.495 rows=3,515,837 loops=1)

3. 82.900 192.888 ↑ 1.0 364,284 1

Hash (cost=16,203.76..16,203.76 rows=364,376 width=8) (actual time=192.888..192.888 rows=364,284 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 14230kB
4. 109.988 109.988 ↑ 1.0 364,284 1

Seq Scan on mst_pm_patient p (cost=0.00..16,203.76 rows=364,376 width=8) (actual time=0.003..109.988 rows=364,284 loops=1)

Planning time : 0.440 ms
Execution time : 3,324.195 ms