explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yovb

Settings
# exclusive inclusive rows x rows loops node
1. 1.159 2.876 ↓ 1.0 204 1

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

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

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

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

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

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

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

5. 0.057 0.853 ↓ 2.5 79 1

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

6. 0.389 0.796 ↓ 1.4 389 1

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

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

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

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

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

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

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

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

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

Planning time : 0.441 ms
Execution time : 2.961 ms