explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sKHJ

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.027 803.712 ↑ 1,236.3 6 1

Sort (cost=46,968.96..46,987.51 rows=7,418 width=34) (actual time=803.711..803.712 rows=6 loops=1)

  • Sort Key: (count(*)) DESC
  • Sort Method: quicksort Memory: 25kB
2. 379.848 803.685 ↑ 1,236.3 6 1

GroupAggregate (cost=45,472.09..46,492.10 rows=7,418 width=34) (actual time=482.952..803.685 rows=6 loops=1)

  • Group Key: (date_trunc('day'::text, _bandsintown_2019_08_01."timestamp")), _bandsintown_2019_08_01.action
3. 58.188 423.837 ↑ 1.0 73,977 1

Sort (cost=45,472.09..45,657.55 rows=74,183 width=51) (actual time=417.758..423.837 rows=73,977 loops=1)

  • Sort Key: (date_trunc('day'::text, _bandsintown_2019_08_01."timestamp")), _bandsintown_2019_08_01.action
  • Sort Method: quicksort Memory: 12744kB
4. 365.649 365.649 ↑ 1.0 73,977 1

Seq Scan on _bandsintown_2019_08_01 (cost=0.00..39,471.13 rows=74,183 width=51) (actual time=0.114..365.649 rows=73,977 loops=1)

  • Filter: (("timestamp" >= '2019-08-01 00:00:00+00'::timestamp with time zone) AND ("timestamp" < '2019-08-02 00:00:00+00'::timestamp with time zone) AND (base_aid = 'bandsintown'::text) AND (action = ANY ('{PIN_HOVER,INTERACTION,PAGELOAD,PAGEVIEW,TRUE_PAGEVIEW,PIN_CLICK}'::text[])))
  • Rows Removed by Filter: 83564
Planning time : 0.197 ms
Execution time : 804.937 ms