explain.depesz.com

PostgreSQL's explain analyze made readable

Result: e7hU

Settings
# exclusive inclusive rows x rows loops node
1. 985.075 2,859.196 ↑ 1.0 1 1

Hash Right Join (cost=4,973.44..180,022.43 rows=1 width=179) (actual time=607.341..2,859.196 rows=1 loops=1)

  • Hash Cond: (offer0_1_.id = offer0_.id)
2. 1,603.111 1,603.111 ↑ 1.0 227,198 1

Seq Scan on travel_offer offer0_1_ (cost=0.00..174,196.98 rows=227,198 width=16) (actual time=0.029..1,603.111 rows=227,198 loops=1)

3. 0.014 271.010 ↑ 1.0 1 1

Hash (cost=4,973.43..4,973.43 rows=1 width=175) (actual time=271.005..271.010 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
4. 129.586 270.996 ↑ 1.0 1 1

Hash Right Join (cost=8.45..4,973.43 rows=1 width=175) (actual time=0.054..270.996 rows=1 loops=1)

  • Hash Cond: (offer0_2_.id = offer0_.id)
5. 141.376 141.376 ↑ 1.0 23,412 1

Seq Scan on vehicle_offer offer0_2_ (cost=0.00..4,877.16 rows=23,416 width=66) (actual time=0.008..141.376 rows=23,412 loops=1)

6. 0.014 0.034 ↑ 1.0 1 1

Hash (cost=8.44..8.44 rows=1 width=109) (actual time=0.029..0.034 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
7. 0.020 0.020 ↑ 1.0 1 1

Index Scan using idx_offer_uuid on offer offer0_ (cost=0.42..8.44 rows=1 width=109) (actual time=0.012..0.020 rows=1 loops=1)

  • Index Cond: (uuid = '1a440d7c-3709-11ea-aa81-632b421734f5'::uuid)