explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1Z5t

Settings
# exclusive inclusive rows x rows loops node
1. 854.099 13,617.675 ↑ 2,258.2 3,321 1

GroupAggregate (cost=1,319,600.90..1,563,334.95 rows=7,499,509 width=64) (actual time=11,427.964..13,617.675 rows=3,321 loops=1)

  • Group Key: c.corp_region, f.as_of_dt, f.schdat, f.wquota
2. 7,554.805 12,763.576 ↑ 6.4 1,181,002 1

Sort (cost=1,319,600.90..1,338,349.68 rows=7,499,509 width=64) (actual time=11,423.373..12,763.576 rows=1,181,002 loops=1)

  • Sort Key: c.corp_region, f.as_of_dt, f.schdat, f.wquota
  • Sort Method: external merge Disk: 57,712kB
3. 1,939.438 5,208.771 ↑ 6.4 1,181,002 1

Merge Join (cost=88.60..181,251.29 rows=7,499,509 width=64) (actual time=8.601..5,208.771 rows=1,181,002 loops=1)

  • Merge Cond: (f.corp = c.corp)
4. 2,680.490 2,680.490 ↑ 1.0 1,181,002 1

Index Scan using indx_tmp_kom_future_pending_jobs_02 on tmp_kom_future_pending_jobs f (cost=0.43..65,717.92 rows=1,181,025 width=36) (actual time=8.500..2,680.490 rows=1,181,002 loops=1)

  • Filter: (wquota IS NOT NULL)
  • Rows Removed by Filter: 2
5. 588.808 588.843 ↓ 916.5 1,163,980 1

Sort (cost=88.17..91.35 rows=1,270 width=36) (actual time=0.096..588.843 rows=1,163,980 loops=1)

  • Sort Key: c.corp
  • Sort Method: quicksort Memory: 27kB
6. 0.035 0.035 ↑ 25.4 50 1

Seq Scan on d_corp_region c (cost=0.00..22.70 rows=1,270 width=36) (actual time=0.010..0.035 rows=50 loops=1)