explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6MqY

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 1,101.580 ↓ 1.8 7 1

Limit (cost=422.76..422.77 rows=4 width=16) (actual time=1,101.578..1,101.580 rows=7 loops=1)

2. 0.009 1,101.578 ↓ 1.8 7 1

Sort (cost=422.76..422.77 rows=4 width=16) (actual time=1,101.577..1,101.578 rows=7 loops=1)

  • Sort Key: (max(monthlyrat.rating)) DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.010 1,101.569 ↓ 1.8 7 1

GroupAggregate (cost=422.65..422.72 rows=4 width=16) (actual time=1,101.566..1,101.569 rows=7 loops=1)

  • Group Key: monthlyrat.company_id
4. 0.023 1,101.559 ↓ 1.8 7 1

Sort (cost=422.65..422.66 rows=4 width=16) (actual time=1,101.558..1,101.559 rows=7 loops=1)

  • Sort Key: monthlyrat.company_id
  • Sort Method: quicksort Memory: 25kB
5. 0.002 1,101.536 ↓ 1.8 7 1

Append (cost=373.45..422.61 rows=4 width=16) (actual time=1,101.118..1,101.536 rows=7 loops=1)

6. 0.486 1,101.534 ↓ 1.8 7 1

Bitmap Heap Scan on _hyper_46_881_chunk monthlyrat (cost=373.45..422.61 rows=4 width=16) (actual time=1,101.117..1,101.534 rows=7 loops=1)

  • Recheck Cond: ((parent_addr_client_id = '2'::text) AND (city_id = '5'::text))
  • Filter: ((region_id = '6'::text) AND (calc_date = '2019-10-11'::date))
  • Rows Removed by Filter: 33
  • Heap Blocks: exact=39
7. 0.306 1,101.048 ↓ 0.0 0 1

BitmapAnd (cost=373.45..373.45 rows=44 width=0) (actual time=1,101.048..1,101.048 rows=0 loops=1)

8. 0.644 0.644 ↑ 1.1 3,884 1

Bitmap Index Scan on _hyper_46_881_chunk_ix_monthly_ratings_paci (cost=0.00..50.71 rows=4,358 width=0) (actual time=0.644..0.644 rows=3,884 loops=1)

  • Index Cond: (parent_addr_client_id = '2'::text)
9. 1,100.098 1,100.098 ↑ 1.0 27,633 1

Bitmap Index Scan on _hyper_46_881_chunk_ix_monthly_ratings_c (cost=0.00..322.50 rows=28,422 width=0) (actual time=1,100.098..1,100.098 rows=27,633 loops=1)

  • Index Cond: (city_id = '5'::text)
Planning time : 0.416 ms