explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UvJj

Settings
# exclusive inclusive rows x rows loops node
1. 0.043 519.343 ↓ 66.0 66 1

GroupAggregate (cost=388,613.49..388,613.51 rows=1 width=40) (actual time=519.306..519.343 rows=66 loops=1)

  • Group Key: employee_id, period_date
2. 0.027 519.300 ↓ 66.0 66 1

Sort (cost=388,613.49..388,613.49 rows=1 width=14) (actual time=519.295..519.300 rows=66 loops=1)

  • Sort Key: employee_id, period_date
  • Sort Method: quicksort Memory: 28kB
3. 519.273 519.273 ↓ 66.0 66 1

Index Scan using slr_in_out_charges_period_date on slr_in_out_charges (cost=0.44..388,613.48 rows=1 width=14) (actual time=372.424..519.273 rows=66 loops=1)

  • Index Cond: ((period_date <= '2019-03-01'::date) AND (period_date >= '2019-01-01'::date))
  • Filter: ((NOT is_death_charge) AND (NOT no_show_charge) AND (ent_id = 1977) AND (type = 3) AND (source = 2))
  • Rows Removed by Filter: 1019417