explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Iwbt : Optimization for: Optimization for: plan #sKHJ; plan #XkmU

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.022 881.697 ↑ 33.3 6 1

Sort (cost=46,039.57..46,040.07 rows=200 width=26) (actual time=881.696..881.697 rows=6 loops=1)

  • Sort Key: (count(DISTINCT _bandsintown_2019_08_01.sessdionid)) DESC
  • Sort Method: quicksort Memory: 25kB
2. 475.198 881.675 ↑ 33.3 6 1

GroupAggregate (cost=45,287.78..46,031.93 rows=200 width=26) (actual time=468.866..881.675 rows=6 loops=1)

  • Group Key: _bandsintown_2019_08_01.action
3. 48.435 406.477 ↑ 1.0 73,977 1

Sort (cost=45,287.78..45,473.32 rows=74,215 width=43) (actual time=400.316..406.477 rows=73,977 loops=1)

  • Sort Key: _bandsintown_2019_08_01.action
  • Sort Method: quicksort Memory: 8,852kB
4. 358.042 358.042 ↑ 1.0 73,977 1

Seq Scan on _bandsintown_2019_08_01 (cost=0.00..39,284.00 rows=74,215 width=43) (actual time=0.093..358.042 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: 83,564
Planning time : 0.189 ms
Execution time : 882.885 ms