explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YdkR0

Settings
# exclusive inclusive rows x rows loops node
1. 4.417 32.987 ↓ 1.0 204 1

Merge Left Join (cost=24.92..49.17 rows=197 width=32) (actual time=25.934..32.987 rows=204 loops=1)

  • Merge Cond: (mt.id = last_known_locations.manifest_id)
2. 3.513 3.513 ↓ 1.0 204 1

Index Only Scan using pk_master_trips_id on master_trips mt (cost=0.27..23.22 rows=197 width=16) (actual time=1.423..3.513 rows=204 loops=1)

  • Heap Fetches: 8
3. 2.187 25.057 ↓ 2.4 78 1

Sort (cost=24.65..24.73 rows=32 width=24) (actual time=24.464..25.057 rows=78 loops=1)

  • Sort Key: last_known_locations.manifest_id
  • Sort Method: quicksort Memory: 28kB
4. 4.406 22.870 ↓ 2.5 79 1

HashAggregate (cost=23.53..23.85 rows=32 width=24) (actual time=22.194..22.870 rows=79 loops=1)

  • Group Key: last_known_locations.manifest_id
5. 8.018 18.464 ↓ 1.4 389 1

Hash Join (cost=11.21..22.82 rows=285 width=16) (actual time=7.709..18.464 rows=389 loops=1)

  • Hash Cond: (last_known_locations.address_id = addresses.hash_id)
6. 4.300 4.300 ↓ 1.4 389 1

Seq Scan on last_known_locations (cost=0.00..10.85 rows=285 width=49) (actual time=0.489..4.300 rows=389 loops=1)

7. 3.778 6.146 ↑ 1.2 226 1

Hash (cost=7.76..7.76 rows=276 width=33) (actual time=6.137..6.146 rows=226 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 23kB
8. 2.368 2.368 ↑ 1.2 226 1

Seq Scan on addresses (cost=0.00..7.76 rows=276 width=33) (actual time=0.093..2.368 rows=226 loops=1)