explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cy7Z

Settings
# exclusive inclusive rows x rows loops node
1. 0.157 4,361.819 ↑ 1.0 1 1

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

2. 0.471 4,356.136 ↑ 1.0 1 1

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

  • Join Filter: (sale0_.seller_log = sellerlog1_.id)
  • Rows Removed by Join Filter: 5
3. 6.025 6.025 ↓ 6.0 6 1

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

  • Filter: (seller = 2,381,146)
  • Rows Removed by Filter: 5,742
4. 4,349.640 4,349.640 ↑ 2.0 1 6

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

  • Filter: ((identifier)::text = '827CB05A-5AC1-48E5-A70E-7D5AF179757C'::text)
  • Rows Removed by Filter: 651,394
5. 5.526 5.526 ↓ 0.0 0 1

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

  • Index Cond: (sale = sale0_.id)
  • Heap Fetches: 0
Execution time : 4,362.794 ms