explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HN6q

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 1,398.907 94,112.317 ↑ 1,884.4 68 1

GroupAggregate (cost=220,004.34..231,894.94 rows=128,137 width=91) (actual time=92,599.427..94,112.317 rows=68 loops=1)

  • Group Key: (COALESCE(COALESCE((data ->> 'abtestName'::text), ((data -> 'abtest'::text) ->> 'version'::text)), ''::text)), (COALESCE((data ->> 'campaignID'::text), sub_aid)), action
  • Functions: 9
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 1.921 ms, Inlining 0.000 ms, Optimization 0.755 ms, Emission 13.490 ms, Total 16.166 ms
2. 839.449 92,713.410 ↑ 1.0 621,734 1

Sort (cost=220,004.34..221,558.99 rows=621,857 width=108) (actual time=92,599.385..92,713.410 rows=621,734 loops=1)

  • Sort Key: (COALESCE(COALESCE((data ->> 'abtestName'::text), ((data -> 'abtest'::text) ->> 'version'::text)), ''::text)), (COALESCE((data ->> 'campaignID'::text), sub_aid)), action
  • Sort Method: quicksort Memory: 110172kB
3. 91,873.961 91,873.961 ↑ 1.0 621,734 1

Seq Scan on bandsintown_2020_01_01 (cost=0.00..160,162.35 rows=621,857 width=108) (actual time=40.511..91,873.961 rows=621,734 loops=1)

  • Filter: (action IS NOT NULL)
  • Rows Removed by Filter: 23
Execution time : 94,122.405 ms