explain.depesz.com

PostgreSQL's explain analyze made readable

Result: y1mT

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 121.552 ↓ 0.0 0 1

Limit (cost=50,258.07..50,258.08 rows=1 width=30) (actual time=121.551..121.552 rows=0 loops=1)

2. 0.001 121.550 ↓ 0.0 0 1

Group (cost=50,258.07..50,258.08 rows=1 width=30) (actual time=121.550..121.550 rows=0 loops=1)

  • Group Key: day_id, group_id, group_name
3. 0.010 121.549 ↓ 0.0 0 1

Sort (cost=50,258.07..50,258.07 rows=1 width=26) (actual time=121.549..121.549 rows=0 loops=1)

  • Sort Key: day_id, group_id, group_name
  • Sort Method: quicksort Memory: 25kB
4. 121.539 121.539 ↓ 0.0 0 1

Index Scan using report_daily_group_action_results_key on report_daily_by_group_action_results (cost=0.56..50,258.06 rows=1 width=26) (actual time=121.539..121.539 rows=0 loops=1)

  • Index Cond: ((day_id >= 20200101) AND (day_id <= 20200130) AND ((mpi_key)::text = 'd43417c6-43e3-40ca-8b1d-391492ed2048'::text) AND ((group_slug)::text = '02et92p01p20drf'::text))
Planning time : 0.181 ms
Execution time : 121.596 ms