explain.depesz.com

PostgreSQL's explain analyze made readable

Result: azkJ

Settings
# exclusive inclusive rows x rows loops node
1. 1,154.101 3,386.772 ↑ 1.0 1 1

Hash Right Join (cost=4,973.44..180,012.83 rows=1 width=179) (actual time=978.946..3,386.772 rows=1 loops=1)

  • Hash Cond: (offer0_1_.id = offer0_.id)
2. 2,018.417 2,018.417 ↓ 1.0 227,200 1

Seq Scan on travel_offer offer0_1_ (cost=0.00..174,190.00 rows=226,500 width=16) (actual time=8.538..2,018.417 rows=227,200 loops=1)

3. 0.015 214.254 ↑ 1.0 1 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
4. 103.738 214.239 ↑ 1.0 1 1

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

  • Hash Cond: (offer0_2_.id = offer0_.id)
5. 110.465 110.465 ↑ 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.009..110.465 rows=23,412 loops=1)

6. 0.015 0.036 ↑ 1.0 1 1

Hash (cost=8.44..8.44 rows=1 width=109) (actual time=0.032..0.036 rows=1 loops=1)

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

Index Scan using ""UQ_Offer_Uuid"" on offer offer0_ (cost=0.42..8.44 rows=1 width=109) (actual time=0.013..0.021 rows=1 loops=1)

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