explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6MoA

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 9,288.009 ↓ 0.0 0 1

GroupAggregate (cost=511,298.31..511,298.34 rows=1 width=40) (actual time=9,288.009..9,288.009 rows=0 loops=1)

  • Group Key: employee_id, period_date
2. 0.000 9,288.007 ↓ 0.0 0 1

Sort (cost=511,298.31..511,298.32 rows=1 width=14) (actual time=9,288.007..9,288.007 rows=0 loops=1)

  • Sort Key: employee_id, period_date
  • Sort Method: quicksort Memory: 25kB
3. 47.686 9,308.795 ↓ 0.0 0 1

Gather (cost=1,000.00..511,298.30 rows=1 width=14) (actual time=9,287.997..9,308.795 rows=0 loops=1)

  • Workers Planned: 6
  • Workers Launched: 6
4. 9,261.109 9,261.109 ↓ 0.0 0 7

Parallel Seq Scan on slr_in_out_charges (cost=0.00..510,298.20 rows=1 width=14) (actual time=9,261.109..9,261.109 rows=0 loops=7)

  • Filter: ((NOT is_death_charge) AND (NOT no_show_charge) AND (period_date <= '2019-03-01'::date) AND (period_date >= '2017-01-01'::date) AND (ent_id = 7615) AND (type = 3) AND (source = 7))
  • Rows Removed by Filter: 4071530