explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aCE0

Settings
# exclusive inclusive rows x rows loops node
1. 0.037 10.189 ↓ 1.4 328 1

Limit (cost=893.92..894.50 rows=231 width=883) (actual time=10.057..10.189 rows=328 loops=1)

  • Buffers: shared hit=21 read=169 dirtied=1
2. 0.417 10.152 ↓ 1.4 328 1

Sort (cost=893.92..894.50 rows=231 width=883) (actual time=10.054..10.152 rows=328 loops=1)

  • Sort Key: pl.generated_at DESC
  • Sort Method: quicksort Memory: 112kB
  • Buffers: shared hit=21 read=169 dirtied=1
3. 2.167 9.735 ↓ 1.4 328 1

Hash Left Join (cost=65.19..884.85 rows=231 width=883) (actual time=0.943..9.735 rows=328 loops=1)

  • Hash Cond: (pl.administrator_id = a.id)
  • Buffers: shared hit=21 read=169 dirtied=1
4. 0.248 7.327 ↓ 1.4 328 1

Hash Join (cost=47.56..860.57 rows=231 width=608) (actual time=0.500..7.327 rows=328 loops=1)

  • Hash Cond: (pl.position_source_id = ps.id)
  • Buffers: shared hit=6 read=169 dirtied=1
5. 6.686 7.066 ↓ 1.4 328 1

Bitmap Heap Scan on position_log_data pl (cost=18.21..828.04 rows=231 width=578) (actual time=0.441..7.066 rows=328 loops=1)

  • Recheck Cond: (vehicle_id = 3275)
  • Heap Blocks: exact=167
  • Buffers: shared hit=5 read=169 dirtied=1
6. 0.380 0.380 ↓ 1.4 328 1

Bitmap Index Scan on position_log_vehicle_position_idx (cost=0.00..18.15 rows=231 width=0) (actual time=0.380..0.380 rows=328 loops=1)

  • Index Cond: (vehicle_id = 3275)
  • Buffers: shared hit=4 read=3
7. 0.005 0.013 ↑ 172.0 5 1

Hash (cost=18.60..18.60 rows=860 width=34) (actual time=0.013..0.013 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
8. 0.008 0.008 ↑ 172.0 5 1

Seq Scan on position_source ps (cost=0.00..18.60 rows=860 width=34) (actual time=0.008..0.008 rows=5 loops=1)

  • Buffers: shared hit=1
9. 0.036 0.241 ↑ 1.1 111 1

Hash (cost=16.17..16.17 rows=117 width=155) (actual time=0.241..0.241 rows=111 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 29kB
  • Buffers: shared hit=15
10. 0.205 0.205 ↑ 1.1 111 1

Seq Scan on administrator a (cost=0.00..16.17 rows=117 width=155) (actual time=0.009..0.205 rows=111 loops=1)

  • Buffers: shared hit=15