explain.depesz.com

PostgreSQL's explain analyze made readable

Result: E95J

Settings
# exclusive inclusive rows x rows loops node
1. 0.057 164.450 ↓ 1.4 321 1

Limit (cost=871.56..872.12 rows=226 width=883) (actual time=164.351..164.450 rows=321 loops=1)

2. 0.804 164.393 ↓ 1.4 321 1

Sort (cost=871.56..872.12 rows=226 width=883) (actual time=164.350..164.393 rows=321 loops=1)

  • Sort Key: pl.generated_at DESC
  • Sort Method: quicksort Memory: 110kB
3. 5.014 163.589 ↓ 1.4 321 1

Hash Left Join (cost=61.02..862.72 rows=226 width=883) (actual time=4.802..163.589 rows=321 loops=1)

  • Hash Cond: (pl.administrator_id = a.id)
4. 0.798 158.301 ↓ 1.4 321 1

Hash Join (cost=43.52..838.72 rows=226 width=608) (actual time=4.305..158.301 rows=321 loops=1)

  • Hash Cond: (pl.position_source_id = ps.id)
5. 154.294 157.484 ↓ 1.4 321 1

Bitmap Heap Scan on position_log_data pl (cost=14.17..806.26 rows=226 width=578) (actual time=4.184..157.484 rows=321 loops=1)

  • Recheck Cond: (vehicle_id = 3275)
  • Heap Blocks: exact=164
6. 3.190 3.190 ↓ 1.4 321 1

Bitmap Index Scan on position_log_vehicle_position_idx (cost=0.00..14.12 rows=226 width=0) (actual time=3.190..3.190 rows=321 loops=1)

  • Index Cond: (vehicle_id = 3275)
7. 0.006 0.019 ↑ 172.0 5 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
8. 0.013 0.013 ↑ 172.0 5 1

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

9. 0.036 0.274 ↑ 1.0 111 1

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

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

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