explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iQDd

Settings
# exclusive inclusive rows x rows loops node
1. 195.978 103,826.166 ↑ 1.0 4 1

HashAggregate (cost=685.15..685.19 rows=4 width=15) (actual time=103,826.161..103,826.166 rows=4 loops=1)

  • Group Key: pricing_plan_type_first
2. 103,630.188 103,630.188 ↓ 199.7 93,679 1

Index Scan using ek_rpt_fin_signups_customer_movement_date_casted_index on ek_rpt_fin_signups_customer_movement (cost=0.42..682.80 rows=469 width=11) (actual time=13.492..103,630.188 rows=93,679 loops=1)

  • Index Cond: (((signup_date)::date >= '2015-05-05'::date) AND ((signup_date)::date <= CURRENT_DATE))
Planning time : 2.673 ms
Execution time : 103,826.432 ms