explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TgKs : Optimization for: Optimization for: plan #HN6q; plan #uZGl

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 1,251.186 44,794.665 ↑ 1,857.1 69 1

GroupAggregate (cost=220,006.73..231,897.64 rows=128,137 width=123) (actual time=43,439.603..44,794.665 rows=69 loops=1)

  • Group Key: (COALESCE(COALESCE((data ->> 'abtestName'::text), ((data -> 'abtest'::text) ->> 'version'::text)), ''::text)), (COALESCE((data ->> 'campaignID'::text), sub_aid)), action
  • Functions: 7
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 1.467 ms, Inlining 0.000 ms, Optimization 0.613 ms, Emission 10.219 ms, Total 12.300 ms
2. 747.818 43,543.479 ↑ 1.0 621,757 1

Sort (cost=220,006.73..221,561.42 rows=621,878 width=108) (actual time=43,439.573..43,543.479 rows=621,757 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: 110173kB
3. 42,795.661 42,795.661 ↑ 1.0 621,757 1

Seq Scan on bandsintown_2020_01_01 (cost=0.00..160,162.56 rows=621,878 width=108) (actual time=35.003..42,795.661 rows=621,757 loops=1)

Planning time : 0.075 ms
Execution time : 44,802.799 ms