explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2ZCe : LEFT2

Settings
# exclusive inclusive rows x rows loops node
1. 449.036 32,745.711 ↑ 2.2 1,000 1

Hash Join (cost=396.12..273,223.37 rows=2,247 width=3,255) (actual time=31,763.217..32,745.711 rows=1,000 loops=1)

  • Buffers: shared hit=7161 read=238546
2. 32,291.469 32,291.469 ↓ 1.0 2,000,000 1

Seq Scan on callhome_notificationlogs callhome_notificationlogs (cost=0..265,305.93 rows=1,999,693 width=1,377) (actual time=0.027..32,291.469 rows=2,000,000 loops=1)

  • Buffers: shared hit=6763 read=238546
3. 1.278 5.206 ↑ 1.0 500 1

Hash (cost=389.87..389.87 rows=500 width=1,878) (actual time=5.206..5.206 rows=500 loops=1)

  • Buffers: shared hit=398
4. 0.087 3.928 ↑ 1.0 500 1

Limit (cost=0.43..384.87 rows=500 width=1,878) (actual time=0.137..3.928 rows=500 loops=1)

  • Buffers: shared hit=398
5. 3.841 3.841 ↑ 34.3 500 1

Index Scan using eventlog_datetime_index on callhome_eventlogs callhome_eventlogs (cost=0.43..13,192.72 rows=17,158 width=1,878) (actual time=0.135..3.841 rows=500 loops=1)

  • Index Cond: ((callhome_eventlogs.datetime < now()) AND (callhome_eventlogs.datetime > (now() - '30 days'::interval)))
  • Filter: (callhome_eventlogs.eventlog_search ~~ '%super ; micro%'::text)
  • Buffers: shared hit=398