explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lTf2 : dsdfsd

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

Aggregate (cost=261,127.56..261,127.57 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Unique (cost=261,124.20..261,125.16 rows=192 width=4,012) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Sort (cost=261,124.20..261,124.68 rows=192 width=4,012) (actual rows= loops=)

  • Sort Key: a.id
4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=737.12..261,116.92 rows=192 width=4,012) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=736.70..260,273.56 rows=192 width=16) (actual rows= loops=)

  • Hash Cond: (c.orderdetails_id = a.id)
6. 0.000 0.000 ↓ 0.0

Index Only Scan using indx_orderdetailsadditional_1 on orderdetailsadditional c (cost=0.43..226,875.40 rows=8,709,490 width=4) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=733.86..733.86 rows=192 width=20) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Index Scan using indx_orderdetails_3 on orderdetails a (cost=0.56..733.86 rows=192 width=20) (actual rows= loops=)

  • Index Cond: ((customer_id = 1) AND (vip_period_id = 1))
9. 0.000 0.000 ↓ 0.0

Index Only Scan using indx_ciscopricelist_1 on ciscopricelist b (cost=0.43..4.38 rows=1 width=17) (actual rows= loops=)