explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GtnR

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

Nested Loop (cost=1.01..82.25 rows=1 width=104) (actual time=0.021..0.021 rows=0 loops=1)

2. 0.001 0.021 ↓ 0.0 0 1

Nested Loop (cost=0.58..33.91 rows=1 width=8) (actual time=0.021..0.021 rows=0 loops=1)

  • Join Filter: (r.salesman_id = s.id)
3. 0.020 0.020 ↓ 0.0 0 1

Index Scan using salesman_route_date_idx on salesman_route r (cost=0.29..8.31 rows=1 width=16) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: ((route_date >= now()) AND (route_date <= now()))
  • Filter: (enabled AND (NOT is_deleted))
4. 0.000 0.000 ↓ 0.0 0

Index Only Scan using salesman_pkey on salesman s (cost=0.29..25.54 rows=5 width=8) (never executed)

  • Index Cond: (id = ANY ('{1,2,3,4,5}'::bigint[]))
  • Heap Fetches: 0
5. 0.000 0.000 ↓ 0.0 0

Index Scan using salesman_route_detail_route_idx on salesman_route_detail rd (cost=0.42..48.28 rows=5 width=112) (never executed)

  • Index Cond: (route_id = r.id)
  • Filter: (enabled AND (NOT is_deleted))
Planning time : 1.730 ms
Execution time : 0.095 ms