explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7G1A

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=6,975,749.59..7,178,388.50 rows=8,210,165 width=51) (actual rows= loops=)

  • Group Key: profile_identity, (to_char(event_time, 'YYYY-MM'::text))
2. 0.000 0.000 ↓ 0.0

Sort (cost=6,975,749.59..7,000,752.55 rows=10,001,185 width=43) (actual rows= loops=)

  • Sort Key: profile_identity, (to_char(event_time, 'YYYY-MM'::text))
3. 0.000 0.000 ↓ 0.0

Index Scan using ct_event_pk on ct_event (cost=0.70..5,632,729.33 rows=10,001,185 width=43) (actual rows= loops=)

  • Index Cond: ((event_time >= '2019-01-01 00:00:00'::timestamp without time zone) AND (event_time <= '2019-03-31 00:00:00'::timestamp without time zone) AND (event_name = 'App Launched'::text))