explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fICfT

Settings
# exclusive inclusive rows x rows loops node
1. 1.048 1.901 ↓ 1.0 204 1

Hash Left Join (cost=36.58..99.07 rows=197 width=1,395) (actual time=0.669..1.901 rows=204 loops=1)

  • Hash Cond: (master_trips.id = n1.manifest_id)
2. 0.198 0.198 ↓ 1.0 204 1

Seq Scan on master_trips (cost=0.00..61.46 rows=197 width=1,363) (actual time=0.009..0.198 rows=204 loops=1)

  • Filter: (org_id = '80109c3a-36e2-41bd-99bc-792ff9e17cc6'::uuid)
3. 0.025 0.655 ↓ 2.4 78 1

Hash (cost=36.18..36.18 rows=32 width=222) (actual time=0.654..0.655 rows=78 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 26kB
4. 0.018 0.630 ↓ 2.5 79 1

Subquery Scan on n1 (cost=34.44..36.18 rows=32 width=222) (actual time=0.550..0.630 rows=79 loops=1)

5. 0.045 0.612 ↓ 2.5 79 1

Unique (cost=34.44..35.86 rows=32 width=271) (actual time=0.549..0.612 rows=79 loops=1)

6. 0.286 0.567 ↓ 1.4 389 1

Sort (cost=34.44..35.15 rows=285 width=271) (actual time=0.548..0.567 rows=389 loops=1)

  • Sort Key: last_known_locations.manifest_id, last_known_locations.created_at DESC
  • Sort Method: quicksort Memory: 125kB
7. 0.154 0.281 ↓ 1.4 389 1

Hash Join (cost=11.21..22.82 rows=285 width=271) (actual time=0.094..0.281 rows=389 loops=1)

  • Hash Cond: (last_known_locations.address_id = addr.hash_id)
8. 0.040 0.040 ↓ 1.4 389 1

Seq Scan on last_known_locations (cost=0.00..10.85 rows=285 width=156) (actual time=0.003..0.040 rows=389 loops=1)

9. 0.047 0.087 ↑ 1.2 226 1

Hash (cost=7.76..7.76 rows=276 width=99) (actual time=0.087..0.087 rows=226 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 39kB
10. 0.040 0.040 ↑ 1.2 226 1

Seq Scan on addresses addr (cost=0.00..7.76 rows=276 width=99) (actual time=0.004..0.040 rows=226 loops=1)

Planning time : 0.507 ms
Execution time : 1.962 ms