explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MXf

Settings
# exclusive inclusive rows x rows loops node
1. 1,184.956 1,877.668 ↓ 2.5 533,266 1

HashAggregate (cost=33,340.50..35,992.93 rows=212,194 width=81) (actual time=1,460.271..1,877.668 rows=533,266 loops=1)

  • Group Key: rt.communicable_diseases_type_id, dc.patient_age, dc.gender, dc.clinic_type_id, dc.region_id, dc.patient_ids
2. 501.552 692.712 ↓ 3.3 704,418 1

Hash Join (cost=20.26..29,627.10 rows=212,194 width=81) (actual time=0.202..692.712 rows=704,418 loops=1)

  • Hash Cond: (dc.mkb10_service_id = rt.mkb10_id)
3. 190.971 190.971 ↑ 1.0 705,860 1

Seq Scan on health_communicable_diseases_calculations dc (cost=0.00..23,955.60 rows=705,860 width=81) (actual time=0.005..190.971 rows=705,860 loops=1)

4. 0.079 0.189 ↑ 1.0 246 1

Hash (cost=17.19..17.19 rows=246 width=16) (actual time=0.189..0.189 rows=246 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 20kB
5. 0.110 0.110 ↑ 1.0 246 1

Seq Scan on reg_mkb10_to_register_types rt (cost=0.00..17.19 rows=246 width=16) (actual time=0.032..0.110 rows=246 loops=1)

  • Filter: (communicable_diseases_type_id IS NOT NULL)
  • Rows Removed by Filter: 573
Planning time : 0.242 ms
Execution time : 1,965.934 ms