explain.depesz.com

PostgreSQL's explain analyze made readable

Result: onYc

Settings
# exclusive inclusive rows x rows loops node
1. 1.074 1.962 ↓ 1.0 204 1

Hash Left Join (cost=37.30..99.78 rows=197 width=1,395) (actual time=0.732..1.962 rows=204 loops=1)

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

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

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

Hash (cost=36.90..36.90 rows=32 width=222) (actual time=0.718..0.718 rows=78 loops=1)

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

Subquery Scan on n1 (cost=35.15..36.90 rows=32 width=222) (actual time=0.612..0.694 rows=79 loops=1)

5. 0.044 0.673 ↓ 2.5 79 1

Unique (cost=35.15..36.58 rows=32 width=271) (actual time=0.611..0.673 rows=79 loops=1)

6. 0.314 0.629 ↓ 1.4 389 1

Sort (cost=35.15..35.86 rows=285 width=271) (actual time=0.610..0.629 rows=389 loops=1)

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

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

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

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

  • Filter: (org_id = '80109c3a-36e2-41bd-99bc-792ff9e17cc6'::uuid)
9. 0.047 0.087 ↑ 1.2 226 1

Hash (cost=7.76..7.76 rows=276 width=99) (actual time=0.086..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.404 ms
Execution time : 2.022 ms