explain.depesz.com

PostgreSQL's explain analyze made readable

Result: geIX

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.400 846.490 ↓ 155.0 155 1

GroupAggregate (cost=28,187.63..28,187.66 rows=1 width=40) (actual time=845.981..846.490 rows=155 loops=1)

  • Group Key: employee_id, period_date
2. 0.486 846.090 ↓ 1,319.0 1,319 1

Sort (cost=28,187.63..28,187.64 rows=1 width=14) (actual time=845.973..846.090 rows=1,319 loops=1)

  • Sort Key: employee_id, period_date
  • Sort Method: quicksort Memory: 111kB
3. 7.108 845.604 ↓ 1,319.0 1,319 1

Bitmap Heap Scan on slr_in_out_charges (cost=23,940.93..28,187.62 rows=1 width=14) (actual time=839.106..845.604 rows=1,319 loops=1)

  • Recheck Cond: ((ent_id = 5103) AND (period_date <= '2019-02-01'::date) AND (period_date >= '2019-02-01'::date))
  • Filter: ((NOT is_death_charge) AND (NOT no_show_charge) AND (type = 1) AND (source = 3))
  • Rows Removed by Filter: 1169
  • Heap Blocks: exact=248
4. 0.487 838.496 ↓ 0.0 0 1

BitmapAnd (cost=23,940.93..23,940.93 rows=2,169 width=0) (actual time=838.496..838.496 rows=0 loops=1)

5. 12.462 12.462 ↑ 1.0 71,767 1

Bitmap Index Scan on slr_in_out__ent_id_fda727_idx (cost=0.00..1,087.63 rows=75,075 width=0) (actual time=12.462..12.462 rows=71,767 loops=1)

  • Index Cond: (ent_id = 5103)
6. 825.547 825.547 ↓ 1.2 1,488,448 1

Bitmap Index Scan on slr_in_out_charges_period_date (cost=0.00..22,853.05 rows=1,246,649 width=0) (actual time=825.547..825.547 rows=1,488,448 loops=1)

  • Index Cond: ((period_date <= '2019-02-01'::date) AND (period_date >= '2019-02-01'::date))