explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AZPm

Settings
# exclusive inclusive rows x rows loops node
1. 2.235 199.615 ↓ 0.0 0 1

Gather (cost=1,000.00..129,327.26 rows=1 width=94) (actual time=199.615..199.615 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 197.380 197.380 ↓ 0.0 0 3

Parallel Seq Scan on pj_mh_dtl (cost=0.00..128,327.16 rows=1 width=94) (actual time=197.380..197.380 rows=0 loops=3)

  • Filter: ((pmd_stay_date >= '2018-09-01'::date) AND (pmd_stay_date <= '2018-10-30'::date) AND ((pmd_prop_code)::text = 'NYCMQ'::text))
  • Rows Removed by Filter: 1721133