explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 81xC

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

Limit (cost=1.29..679.62 rows=100 width=126) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.29..174,474,019.86 rows=25,720,838 width=126) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.00..14,590,775.72 rows=25,720,838 width=34) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Only Scan Backward using tbl_order_delivery_pkey on tbl_order_delivery d (cost=0.56..588,644.31 rows=25,720,838 width=4) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Index Scan using tbl_order_pkey on tbl_order o (cost=0.44..0.54 rows=1 width=34) (actual rows= loops=)

  • Index Cond: (id = d.id)
6. 0.000 0.000 ↓ 0.0

Index Scan using tbl_user_bo_pkey on tbl_user_bo userbo (cost=0.29..0.30 rows=1 width=38) (actual rows= loops=)

  • Index Cond: (o.user_bo_id = id)
7.          

SubPlan (for Nested Loop Left Join)

8. 0.000 0.000 ↓ 0.0

Seq Scan on lst_order_status (cost=0.00..1.62 rows=1 width=29) (actual rows= loops=)

  • Filter: (id = o.status)
9. 0.000 0.000 ↓ 0.0

Index Scan using lst_source_pkey on lst_source (cost=0.28..4.29 rows=1 width=31) (actual rows= loops=)

  • Index Cond: (id = o.source_id)