explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iWv5

Settings
# exclusive inclusive rows x rows loops node
1. 0.280 5,830.658 ↓ 1.1 42 1

Nested Loop (cost=9.17..6,847.82 rows=40 width=50) (actual time=215.260..5,830.658 rows=42 loops=1)

2. 0.138 0.148 ↓ 1.1 42 1

Bitmap Heap Scan on hardware_controller hc (cost=8.61..157.80 rows=40 width=4) (actual time=0.016..0.148 rows=42 loops=1)

  • Recheck Cond: (id > 16450)
  • Filter: (deleted_at IS NULL)
  • Heap Blocks: exact=8
3. 0.010 0.010 ↑ 1.0 42 1

Bitmap Index Scan on hardware_controller_pkey (cost=0.00..8.60 rows=42 width=0) (actual time=0.010..0.010 rows=42 loops=1)

  • Index Cond: (id > 16450)
4. 0.126 5,830.230 ↑ 1.0 1 42

Limit (cost=0.56..167.23 rows=1 width=46) (actual time=138.814..138.815 rows=1 loops=42)

5. 5,830.104 5,830.104 ↑ 2,312.0 1 42

Index Scan Backward using controller_event_log_published_at_idx on controller_event_log (cost=0.56..385,330.99 rows=2,312 width=46) (actual time=138.812..138.812 rows=1 loops=42)

  • Index Cond: (published_at > '2018-12-18 00:00:00+00'::timestamp with time zone)
  • Filter: (controller_id = hc.id)
  • Rows Removed by Filter: 213224