explain.depesz.com

PostgreSQL's explain analyze made readable

Result: L2a3 : INNER

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 0.057 ↓ 0.0 0 1

Hash Join (cost=4.48..272,809.3 rows=4 width=3,255) (actual time=0.057..0.057 rows=0 loops=1)

  • Buffers: shared hit=5
2. 0.020 0.020 ↑ 1,999,693.0 1 1

Seq Scan on callhome_notificationlogs b (cost=0..265,305.93 rows=1,999,693 width=1,377) (actual time=0.02..0.02 rows=1 loops=1)

  • Buffers: shared hit=1
3. 0.001 0.028 ↓ 0.0 0 1

Hash (cost=4.47..4.47 rows=1 width=1,878) (actual time=0.028..0.028 rows=0 loops=1)

  • Buffers: shared hit=4
4. 0.001 0.027 ↓ 0.0 0 1

Limit (cost=0.42..4.46 rows=1 width=1,878) (actual time=0.027..0.027 rows=0 loops=1)

  • Buffers: shared hit=4
5. 0.026 0.026 ↓ 0.0 0 1

Index Scan using eventlog_is_notified_index on callhome_eventlogs callhome_eventlogs (cost=0.42..4.46 rows=1 width=1,878) (actual time=0.026..0.026 rows=0 loops=1)

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