explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uZGl : Optimization for: plan #HN6q

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 1,366.828 47,035.837 ↑ 1,884.4 68 1

GroupAggregate (cost=220,004.34..231,894.94 rows=128,137 width=91) (actual time=45,555.688..47,035.837 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.837 ms, Inlining 0.000 ms, Optimization 0.760 ms, Emission 13.732 ms, Total 16.329 ms
2. 828.799 45,669.009 ↑ 1.0 621,734 1

Sort (cost=220,004.34..221,558.99 rows=621,857 width=108) (actual time=45,555.655..45,669.009 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. 44,840.210 44,840.210 ↑ 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=42.185..44,840.210 rows=621,734 loops=1)

  • Filter: (action IS NOT NULL)
  • Rows Removed by Filter: 23
Planning time : 0.083 ms
Execution time : 47,046.968 ms