explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pp6h : NestLoop

Settings
# exclusive inclusive rows x rows loops node
1. 1.389 18.365 ↑ 2.2 1,000 1

Nested Loop (cost=0.86..10,846.01 rows=2,247 width=3,255) (actual time=0.12..18.365 rows=1,000 loops=1)

  • Buffers: shared hit=2914
2. 0.090 6.476 ↑ 1.0 500 1

Limit (cost=0.43..664.38 rows=500 width=1,878) (actual time=0.081..6.476 rows=500 loops=1)

  • Buffers: shared hit=833
3. 6.386 6.386 ↑ 19.2 500 1

Index Scan using eventlog_datetime_index on callhome_eventlogs callhome_eventlogs (cost=0.43..12,716.43 rows=9,576 width=1,878) (actual time=0.079..6.386 rows=500 loops=1)

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

Index Scan using callhome_notificationlogs_event_id_idx on callhome_notificationlogs b (cost=0.43..20.31 rows=4 width=1,377) (actual time=0.02..0.021 rows=2 loops=500)

  • Index Cond: ((b.event_id)::text = (callhome_eventlogs.event_id)::text)
  • Buffers: shared hit=2081