explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JV8Q

Settings
# exclusive inclusive rows x rows loops node
1. 1.229 2.339 ↓ 1.0 204 1

Hash Left Join (cost=110.19..172.68 rows=197 width=1,395) (actual time=0.950..2.339 rows=204 loops=1)

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

Bitmap Heap Scan on master_trips (cost=17.80..79.26 rows=197 width=1,363) (actual time=0.027..0.202 rows=204 loops=1)

  • Recheck Cond: (org_id = '80109c3a-36e2-41bd-99bc-792ff9e17cc6'::uuid)
  • Heap Blocks: exact=50
3. 0.016 0.016 ↓ 1.0 206 1

Bitmap Index Scan on master_trips_org_id (cost=0.00..17.75 rows=197 width=0) (actual time=0.016..0.016 rows=206 loops=1)

  • Index Cond: (org_id = '80109c3a-36e2-41bd-99bc-792ff9e17cc6'::uuid)
4. 0.028 0.908 ↓ 2.4 78 1

Hash (cost=92.00..92.00 rows=32 width=222) (actual time=0.908..0.908 rows=78 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 26kB
5. 0.020 0.880 ↓ 2.5 79 1

Subquery Scan on n1 (cost=90.25..92.00 rows=32 width=222) (actual time=0.791..0.880 rows=79 loops=1)

6. 0.051 0.860 ↓ 2.5 79 1

Unique (cost=90.25..91.68 rows=32 width=271) (actual time=0.790..0.860 rows=79 loops=1)

7. 0.324 0.809 ↓ 1.4 389 1

Sort (cost=90.25..90.97 rows=285 width=271) (actual time=0.789..0.809 rows=389 loops=1)

  • Sort Key: last_known_locations.manifest_id, last_known_locations.created_at DESC
  • Sort Method: quicksort Memory: 125kB
8. 0.209 0.485 ↓ 1.4 389 1

Hash Join (cost=66.31..78.63 rows=285 width=271) (actual time=0.229..0.485 rows=389 loops=1)

  • Hash Cond: (last_known_locations.address_id = addr.hash_id)
9. 0.057 0.076 ↓ 1.4 389 1

Bitmap Heap Scan on last_known_locations (cost=18.48..30.04 rows=285 width=156) (actual time=0.024..0.076 rows=389 loops=1)

  • Recheck Cond: (org_id = '80109c3a-36e2-41bd-99bc-792ff9e17cc6'::uuid)
  • Heap Blocks: exact=8
10. 0.019 0.019 ↓ 1.4 389 1

Bitmap Index Scan on idx_last_known_locations_assigned_driver_org_id (cost=0.00..18.41 rows=285 width=0) (actual time=0.019..0.019 rows=389 loops=1)

  • Index Cond: (org_id = '80109c3a-36e2-41bd-99bc-792ff9e17cc6'::uuid)
11. 0.056 0.200 ↑ 1.2 226 1

Hash (cost=44.38..44.38 rows=276 width=99) (actual time=0.199..0.200 rows=226 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 39kB
12. 0.144 0.144 ↑ 1.2 226 1

Index Scan using idx_addresses_hash_id on addresses addr (cost=0.27..44.38 rows=276 width=99) (actual time=0.004..0.144 rows=226 loops=1)

Planning time : 0.570 ms
Execution time : 2.412 ms