explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dKn

Settings
# exclusive inclusive rows x rows loops node
1. 0.024 2.479 ↓ 1.5 317 1

Limit (cost=829.69..830.23 rows=214 width=883) (actual time=2.431..2.479 rows=317 loops=1)

2. 0.160 2.455 ↓ 1.5 317 1

Sort (cost=829.69..830.23 rows=214 width=883) (actual time=2.431..2.455 rows=317 loops=1)

  • Sort Key: pl.generated_at DESC
  • Sort Method: quicksort Memory: 109kB
3. 1.441 2.295 ↓ 1.5 317 1

Hash Left Join (cost=60.93..821.41 rows=214 width=883) (actual time=0.428..2.295 rows=317 loops=1)

  • Hash Cond: (pl.administrator_id = a.id)
4. 0.117 0.649 ↓ 1.5 317 1

Hash Join (cost=43.43..797.75 rows=214 width=608) (actual time=0.178..0.649 rows=317 loops=1)

  • Hash Cond: (pl.position_source_id = ps.id)
5. 0.400 0.516 ↓ 1.5 317 1

Bitmap Heap Scan on position_log_data pl (cost=14.08..765.46 rows=214 width=578) (actual time=0.155..0.516 rows=317 loops=1)

  • Recheck Cond: (vehicle_id = 3275)
  • Heap Blocks: exact=162
6. 0.116 0.116 ↓ 1.5 317 1

Bitmap Index Scan on position_log_vehicle_position_idx (cost=0.00..14.03 rows=214 width=0) (actual time=0.116..0.116 rows=317 loops=1)

  • Index Cond: (vehicle_id = 3275)
7. 0.008 0.016 ↑ 172.0 5 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
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)

9. 0.062 0.205 ↑ 1.0 111 1

Hash (cost=16.11..16.11 rows=111 width=155) (actual time=0.205..0.205 rows=111 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 29kB
10. 0.143 0.143 ↑ 1.0 111 1

Seq Scan on administrator a (cost=0.00..16.11 rows=111 width=155) (actual time=0.011..0.143 rows=111 loops=1)