explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PPcI

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.154 ↓ 0.0 0 1

Limit (cost=40.73..40.74 rows=1 width=16) (actual time=0.154..0.154 rows=0 loops=1)

2. 0.009 0.154 ↓ 0.0 0 1

Sort (cost=40.73..40.74 rows=1 width=16) (actual time=0.154..0.154 rows=0 loops=1)

  • Sort Key: (max(monthlyrat.rating)) DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.001 0.145 ↓ 0.0 0 1

GroupAggregate (cost=40.70..40.72 rows=1 width=16) (actual time=0.145..0.145 rows=0 loops=1)

  • Group Key: monthlyrat.company_id
4. 0.004 0.144 ↓ 0.0 0 1

Sort (cost=40.70..40.71 rows=1 width=16) (actual time=0.144..0.144 rows=0 loops=1)

  • Sort Key: monthlyrat.company_id
  • Sort Method: quicksort Memory: 25kB
5. 0.000 0.140 ↓ 0.0 0 1

Append (cost=39.57..40.69 rows=1 width=16) (actual time=0.140..0.140 rows=0 loops=1)

6. 0.003 0.140 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_46_881_chunk monthlyrat (cost=39.57..40.69 rows=1 width=16) (actual time=0.140..0.140 rows=0 loops=1)

  • Recheck Cond: ((region_id = '54'::text) AND (parent_addr_client_id = '2'::text))
  • Filter: ((city_id = '8'::text) AND (calc_date = '2019-10-11'::date))
7. 0.000 0.137 ↓ 0.0 0 1

BitmapAnd (cost=39.57..39.57 rows=1 width=0) (actual time=0.137..0.137 rows=0 loops=1)

8. 0.137 0.137 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_46_881_chunk_ix_monthly_ratings_r (cost=0.00..3.17 rows=219 width=0) (actual time=0.137..0.137 rows=0 loops=1)

  • Index Cond: (region_id = '54'::text)
9. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on _hyper_46_881_chunk_ix_monthly_ratings_paci (cost=0.00..36.15 rows=3,297 width=0) (never executed)

  • Index Cond: (parent_addr_client_id = '2'::text)
Planning time : 1.044 ms