explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4se1 : Optimization for: plan #HnTv

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.29..26,648.64 rows=1 width=165) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..25,975.34 rows=1 width=157) (actual rows= loops=)

  • Join Filter: (sale0_.seller_log = sellerlog1_.id)
3. 0.000 0.000 ↓ 0.0

Seq Scan on seller_log sellerlog1_ (cost=0.00..207.68 rows=1 width=8) (actual rows= loops=)

  • Filter: (seller = 2,381,146)
4. 0.000 0.000 ↓ 0.0

Seq Scan on sale sale0_ (cost=0.00..25,767.64 rows=2 width=157) (actual rows= loops=)

  • Filter: ((identifier)::text = '827CB05A-5AC1-48E5-A70E-7D5AF179757C'::text)
5. 0.000 0.000 ↓ 0.0

Index Only Scan using trip_sale_trip_sale_key on trip_sale sale0_1_ (cost=0.29..673.29 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (sale = sale0_.id)