explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Nt0h

Settings

Optimization(s) for this plan:

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

Sort (cost=21.34..21.34 rows=2 width=1,212) (actual rows= loops=)

  • Sort Key: order0_.firstslotdate
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..21.33 rows=2 width=1,212) (actual rows= loops=)

  • Join Filter: ((order0_.id)::text = (tourorder1_.orderid)::text)
3. 0.000 0.000 ↓ 0.0

Append (cost=0.00..15.08 rows=2 width=1,210) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on orders_v2 order0_ (cost=0.00..0.00 rows=1 width=1,588) (actual rows= loops=)

  • Filter: ((storeid = 320509) AND ((orderstatus)::text = ANY ('{1,2,3}'::text[])))
5. 0.000 0.000 ↓ 0.0

Index Scan using idx_orders_v2_orderstatus_320509 on orders_v2_320509 order0__1 (cost=0.29..15.08 rows=1 width=833) (actual rows= loops=)

  • Index Cond: ((orderstatus)::text = ANY ('{1,2,3}'::text[]))
  • Filter: (storeid = 320509)
6. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..6.19 rows=2 width=58) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Append (cost=0.00..6.18 rows=2 width=58) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on tourorder_v2 tourorder1_ (cost=0.00..0.00 rows=1 width=102) (actual rows= loops=)

  • Filter: ((storeid = 320509) AND ((tourtype)::text = 'dd'::text))
9. 0.000 0.000 ↓ 0.0

Index Scan using idx_tourorder_v2_tourtype_320509 on tourorder_v2_320509 tourorder1__1 (cost=0.41..6.18 rows=1 width=13) (actual rows= loops=)

  • Index Cond: ((storeid = 320509) AND ((tourtype)::text = 'dd'::text))