explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ncE9d

Settings
# exclusive inclusive rows x rows loops node
1. 93.587 3,547.244 ↑ 1.0 1 1

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

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

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

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

4. 0.014 0.033 ↑ 1.0 1 1

Hash (cost=8.44..8.44 rows=1 width=109) (actual time=0.030..0.033 rows=1 loops=1)

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

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

Planning time : 0.236 ms
Execution time : 3,547.335 ms