explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fa5G

Settings
# exclusive inclusive rows x rows loops node
1. 139.922 3,684.973 ↑ 1.0 1 1

Nested Loop Left Join (cost=8.45..180,217.70 rows=1 width=179) (actual time=969.524..3,684.973 rows=1 loops=1)

  • Join Filter: (offer0_.id = offer0_2_.id)
  • Rows Removed by Join Filter: 23,411
2. 1,151.572 3,389.267 ↑ 1.0 1 1

Hash Right Join (cost=8.45..175,047.84 rows=1 width=125) (actual time=969.499..3,389.267 rows=1 loops=1)

  • Hash Cond: (offer0_1_.id = offer0_.id)
3. 2,237.654 2,237.654 ↓ 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=17.192..2,237.654 rows=227,200 loops=1)

4. 0.015 0.041 ↑ 1.0 1 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
5. 0.026 0.026 ↑ 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.016..0.026 rows=1 loops=1)

  • Index Cond: (uuid = '1a440d7c-3709-11ea-aa81-632b421734f5'::uuid)
6. 155.784 155.784 ↑ 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.010..155.784 rows=23,412 loops=1)