explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bQJD

Settings
# exclusive inclusive rows x rows loops node
1. 559.856 4,555.222 ↓ 10.5 418,204 1

Gather (cost=1,000.57..2,014,214.63 rows=39,744 width=484) (actual time=2.310..4,555.222 rows=418,204 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 3,995.366 3,995.366 ↓ 8.4 139,401 3

Parallel Index Scan using idx_calls_ivr_menu_action_id on calls c (cost=0.56..2,009,240.23 rows=16,560 width=484) (actual time=306.173..3,995.366 rows=139,401 loops=3)

  • Index Cond: (cid = 3049)
  • Filter: ((month_number >= 109) AND (month_number <= 111))
  • Rows Removed by Filter: 2243579