explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fYRB

Settings
# exclusive inclusive rows x rows loops node
1. 0.028 3,971.733 ↓ 5.0 5 1

GroupAggregate (cost=489,610.15..489,610.17 rows=1 width=40) (actual time=3,971.718..3,971.733 rows=5 loops=1)

  • Group Key: employee_id, period_date
2. 0.000 3,971.705 ↓ 29.0 29 1

Sort (cost=489,610.15..489,610.15 rows=1 width=14) (actual time=3,971.701..3,971.705 rows=29 loops=1)

  • Sort Key: employee_id, period_date
  • Sort Method: quicksort Memory: 26kB
3. 36.802 3,978.678 ↓ 29.0 29 1

Gather (cost=1,000.00..489,610.14 rows=1 width=14) (actual time=3,926.065..3,978.678 rows=29 loops=1)

  • Workers Planned: 6
  • Workers Launched: 6
4. 3,941.876 3,941.876 ↓ 4.0 4 7

Parallel Seq Scan on slr_in_out_charges (cost=0.00..488,610.04 rows=1 width=14) (actual time=3,935.496..3,941.876 rows=4 loops=7)

  • Filter: ((NOT is_death_charge) AND (NOT no_show_charge) AND (period_date <= '2019-03-01'::date) AND (period_date >= '2018-01-01'::date) AND (ent_id = 5786) AND (type = 1) AND (source = 3))
  • Rows Removed by Filter: 3939713