explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PlX7

Settings
# exclusive inclusive rows x rows loops node
1. 2.659 6.653 ↓ 1.0 204 1

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

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

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

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

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

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

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

5. 0.050 1.492 ↓ 2.5 79 1

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

6. 0.695 1.442 ↓ 1.4 389 1

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

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

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

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

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

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

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

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

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

Planning time : 16.059 ms
Execution time : 9.293 ms