explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LVcY : Optimization for: plan #iajA

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 334.764 139,112.640 ↓ 1.1 281,279 1

HashAggregate (cost=306,757.47..309,373.85 rows=261,638 width=69) (actual time=139,047.883..139,112.640 rows=281,279 loops=1)

  • Group Key: epic_auth_registrations.epic_id, 'Pre Load Tutorial'::character varying, 1
2. 371.527 138,777.876 ↓ 1.1 281,674 1

Hash Join (cost=35,079.90..304,795.18 rows=261,638 width=69) (actual time=391.137..138,777.876 rows=281,674 loops=1)

  • Hash Cond: (client_events.user_id = epic_auth_registrations.user_id)
3. 138,019.582 138,019.582 ↓ 1.1 281,676 1

Index Scan using client_event_timestamp_order on client_events (cost=0.57..266,118.34 rows=261,638 width=37) (actual time=1.475..138,019.582 rows=281,676 loops=1)

  • Index Cond: ((event = 'pre_load_tutorial'::text) AND ("timestamp" > (now() - '90 days'::interval)))
4. 262.801 386.767 ↓ 1.0 938,123 1

Hash (cost=23,573.59..23,573.59 rows=920,459 width=70) (actual time=386.767..386.767 rows=938,123 loops=1)

  • Buckets: 1048576 Batches: 1 Memory Usage: 101638kB
5. 123.966 123.966 ↓ 1.0 938,123 1

Seq Scan on epic_auth_registrations (cost=0.00..23,573.59 rows=920,459 width=70) (actual time=0.010..123.966 rows=938,123 loops=1)

Planning time : 0.248 ms
Execution time : 139,124.707 ms