explain.depesz.com

PostgreSQL's explain analyze made readable

Result: q88Z

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 13,842.898 ↓ 0.0 0 1

GroupAggregate (cost=148,528.82..148,533.97 rows=229 width=40) (actual time=13,842.898..13,842.898 rows=0 loops=1)

  • Group Key: employee_id, period_date
2. 0.053 13,842.896 ↓ 0.0 0 1

Sort (cost=148,528.82..148,529.39 rows=229 width=14) (actual time=13,842.895..13,842.896 rows=0 loops=1)

  • Sort Key: employee_id, period_date
  • Sort Method: quicksort Memory: 25kB
3. 10,236.411 13,842.843 ↓ 0.0 0 1

Bitmap Heap Scan on slr_in_out_charges (cost=100,392.63..148,519.85 rows=229 width=14) (actual time=13,842.843..13,842.843 rows=0 loops=1)

  • Recheck Cond: ((ent_id = 3913) AND (period_date <= '2020-01-01'::date) AND (period_date >= '2020-01-01'::date))
  • Rows Removed by Index Recheck: 36850
  • Filter: ((NOT is_death_charge) AND (NOT no_show_charge) AND (source = 3) AND (type = 1))
  • Rows Removed by Filter: 1955
  • Heap Blocks: exact=3629
4. 4.188 3,606.432 ↓ 0.0 0 1

BitmapAnd (cost=100,392.63..100,392.63 rows=12,648 width=0) (actual time=3,606.431..3,606.432 rows=0 loops=1)

5. 1,005.950 1,005.950 ↓ 1.1 531,305 1

Bitmap Index Scan on slr_in_out_charges_dict_root_ent_id (cost=0.00..8,941.91 rows=463,645 width=0) (actual time=1,005.950..1,005.950 rows=531,305 loops=1)

  • Index Cond: (ent_id = 3913)
6. 2,596.294 2,596.294 ↑ 1.0 4,209,624 1

Bitmap Index Scan on slr_in_out_charges_period_date (cost=0.00..91,450.36 rows=4,361,379 width=0) (actual time=2,596.294..2,596.294 rows=4,209,624 loops=1)

  • Index Cond: ((period_date <= '2020-01-01'::date) AND (period_date >= '2020-01-01'::date))
Planning time : 1.511 ms
Execution time : 13,843.383 ms