explain.depesz.com

PostgreSQL's explain analyze made readable

Result: K1fs

Settings
# exclusive inclusive rows x rows loops node
1. 7.887 740.198 ↑ 1.0 5,153 1

Gather (cost=17,182.25..69,184.91 rows=5,199 width=92) (actual time=3.373..740.198 rows=5,153 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 1.965 732.311 ↑ 1.3 1,718 3 / 3

Nested Loop Left Join (cost=16,182.25..67,551.27 rows=2,166 width=92) (actual time=1.038..732.311 rows=1,718 loops=3)

3. 1.046 168.669 ↑ 1.3 1,718 3 / 3

Nested Loop Left Join (cost=16,181.68..48,894.52 rows=2,166 width=81) (actual time=1.021..168.669 rows=1,718 loops=3)

4. 1.810 2.727 ↑ 1.3 1,718 3 / 3

Parallel Bitmap Heap Scan on scooter s (cost=16,181.11..30,357.74 rows=2,166 width=77) (actual time=1.005..2.727 rows=1,718 loops=3)

  • Recheck Cond: (state = ANY ('{1,0}'::integer[]))
  • Heap Blocks: exact=374
5. 0.917 0.917 ↓ 1.2 6,080 1 / 3

Bitmap Index Scan on scooter_state_diff_update_time_idx (cost=0.00..16,179.82 rows=5,199 width=0) (actual time=2.750..2.750 rows=6,080 loops=1)

  • Index Cond: (state = ANY ('{1,0}'::integer[]))
6. 164.896 164.896 ↑ 1.0 1 5,153 / 3

Index Scan using scooter_ext_status_history_id_pkey on scooter_ext_status_history sesh (cost=0.57..8.56 rows=1 width=36) (actual time=0.096..0.096 rows=1 loops=5,153)

  • Index Cond: (s.ext_status_history_id = id)
7. 561.677 561.677 ↑ 1.0 1 5,153 / 3

Index Scan using scooter_status_history_id_pkey on scooter_status_history ssh (cost=0.57..8.58 rows=1 width=42) (actual time=0.327..0.327 rows=1 loops=5,153)

  • Index Cond: (s.status_history_id = id)
Planning time : 1.744 ms
Execution time : 740.624 ms