explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 93fS

Settings
# exclusive inclusive rows x rows loops node
1. 10.400 31.588 ↓ 1.0 204 1

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

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

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

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

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

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

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

5. 0.173 10.056 ↓ 2.5 79 1

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

6. 2.993 9.883 ↓ 1.4 389 1

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

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

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

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

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

9. 0.351 3.425 ↑ 1.2 226 1

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

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

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

Planning time : 244.074 ms
Execution time : 33.667 ms