explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CSUO

Settings
# exclusive inclusive rows x rows loops node
1. 2.901 49,125.188 ↑ 3.8 1,000 1

Nested Loop Left Join (cost=0.85..26,024.13 rows=3,796 width=2,881) (actual time=45,228.613..49,125.188 rows=1,000 loops=1)

  • Buffers: shared hit=50758 read=92379
2. 0.198 45,784.287 ↑ 1.0 500 1

Limit (cost=0.42..7,871.39 rows=500 width=1,477) (actual time=45,218.467..45,784.287 rows=500 loops=1)

  • Buffers: shared hit=49481 read=91563
3. 45,784.089 45,784.089 ↑ 89.3 500 1

Index Scan using eventlog_system_serial_number on callhome_eventlogs (cost=0.42..702,657.13 rows=44,636 width=1,477) (actual time=45,218.466..45,784.089 rows=500 loops=1)

  • Filter: (is_notified AND (datetime >= '2019-09-01'::date) AND (datetime <= '2019-10-01'::date) AND ((handler_stage)::text = 'NotificationHandler'::text))
  • Rows Removed by Filter: 238297
  • Buffers: shared hit=49481 read=91563
4. 3,338.000 3,338.000 ↑ 4.0 2 500

Index Scan using notificationlog_fk_index on callhome_notificationlogs b (cost=0.43..36.22 rows=8 width=1,415) (actual time=6.343..6.676 rows=2 loops=500)

  • Index Cond: ((callhome_eventlogs.event_id)::text = (event_id)::text)
  • Buffers: shared hit=1277 read=816
Planning time : 1.061 ms