explain.depesz.com

A tool for finding a real cause for slow queries.

Result: lpN

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

Limit (cost=0.00..1159.15 rows=200 width=584) (actual time=.. rows= loops=)

2. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=0.00..6647.73 rows=1147 width=584) (actual time=.. rows= loops=)

3. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=0.00..6268.74 rows=1147 width=584) (actual time=.. rows= loops=)

4. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=0.00..170.02 rows=1147 width=571) (actual time=.. rows= loops=)

  • Join Filter: (orders.order_source_id = order_sources.id)
5. 0.000 0.000 ↓ 0.0
→

Index Scan Backward using orders_pkey on orders (cost=0.00..100.15 rows=1147 width=59) (actual time=.. rows= loops=)

6. 0.000 0.000 ↓ 0.0
→

Materialize (cost=0.00..1.06 rows=4 width=520) (actual time=.. rows= loops=)

7. 0.000 0.000 ↓ 0.0
→

Seq Scan on order_sources (cost=0.00..1.04 rows=4 width=520) (actual time=.. rows= loops=)

8. 0.000 0.000 ↓ 0.0
→

Index Scan using owners_pkey on owners (cost=0.00..5.30 rows=1 width=17) (actual time=.. rows= loops=)

  • Index Cond: (owners.id = orders.owner_id)
9. 0.000 0.000 ↓ 0.0
→

Index Scan using users_pkey on users (cost=0.00..0.31 rows=1 width=4) (actual time=.. rows= loops=)

  • Index Cond: (users.id = orders.sales_person_id)