explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FyZd : LEFT

Settings
# exclusive inclusive rows x rows loops node
1. 240.213 1,291.535 ↑ 2.2 1,000 1

Hash Join (cost=396.1..273,223.34 rows=2,247 width=3,255) (actual time=4.999..1,291.535 rows=1,000 loops=1)

  • Buffers: shared hit=7021 read=238674
2. 1,046.379 1,046.379 ↓ 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.026..1,046.379 rows=2,000,000 loops=1)

  • Buffers: shared hit=6635 read=238674
3. 1.089 4.943 ↑ 1.0 500 1

Hash (cost=389.85..389.85 rows=500 width=1,878) (actual time=4.943..4.943 rows=500 loops=1)

  • Buffers: shared hit=386
4. 0.094 3.854 ↑ 1.0 500 1

Limit (cost=0.43..384.85 rows=500 width=1,878) (actual time=0.184..3.854 rows=500 loops=1)

  • Buffers: shared hit=386
5. 3.760 3.760 ↑ 34.4 500 1

Index Scan using eventlog_datetime_index on callhome_eventlogs callhome_eventlogs (cost=0.43..13,208.09 rows=17,179 width=1,878) (actual time=0.183..3.76 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=386