explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OLmg

Settings
# exclusive inclusive rows x rows loops node
1. 85.746 149.624 ↓ 19,969.0 19,969 1

GroupAggregate (cost=7.06..7.15 rows=1 width=940) (actual time=62.574..149.624 rows=19,969 loops=1)

  • Group Key: summary, country_id, game_id, currency_id, game_category_symb_id
2. 34.575 63.878 ↓ 19,969.0 19,969 1

Sort (cost=7.06..7.06 rows=1 width=928) (actual time=62.549..63.878 rows=19,969 loops=1)

  • Sort Key: summary, country_id, game_id, currency_id, game_category_symb_id
  • Sort Method: quicksort Memory: 5957kB
3. 29.303 29.303 ↓ 19,969.0 19,969 1

Index Scan using daily_summary_temp1_pk on daily_summary_temp ccgs (cost=0.41..7.05 rows=1 width=928) (actual time=0.166..29.303 rows=19,969 loops=1)

  • Index Cond: ((summary >= '2020-01-01'::date) AND (summary <= '2020-01-31'::date) AND (summary < date_trunc('DAY'::text, ('2020-02-01'::date)::timestamp with time zone)) AND (brand_id = '410'::numeric) AND (platform_id = '1105'::numeric) AND ((server)::text = 'DENMARK'::text))
Planning time : 0.595 ms
Execution time : 150.520 ms