explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rwgY : Optimization for: plan #DDyjA

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.003 2.977 ↓ 0.0 0 1

Sort (cost=1,437.92..1,437.92 rows=1 width=110) (actual time=2.977..2.977 rows=0 loops=1)

  • Sort Key: location.loca_id
  • Sort Method: quicksort Memory: 25kB
2. 0.001 2.974 ↓ 0.0 0 1

Nested Loop (cost=600.77..1,437.91 rows=1 width=110) (actual time=2.974..2.974 rows=0 loops=1)

  • Join Filter: (location.loca_id = balance.loca_id)
3. 0.000 2.973 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.57..813.66 rows=1 width=110) (actual time=2.973..2.973 rows=0 loops=1)

4. 0.000 2.973 ↓ 0.0 0 1

Nested Loop (cost=0.29..805.35 rows=1 width=95) (actual time=2.973..2.973 rows=0 loops=1)

  • Join Filter: (location.owner_part_id = owner.part_id)
5. 2.973 2.973 ↓ 0.0 0 1

Seq Scan on location (cost=0.00..797.04 rows=1 width=103) (actual time=2.973..2.973 rows=0 loops=1)

  • Filter: ((op_licence_nr)::text = '2'::text)
  • Rows Removed by Filter: 13965
6. 0.000 0.000 ↓ 0.0 0

Index Scan using uk_part_mkr_person_id on party owner (cost=0.29..8.30 rows=1 width=8) (never executed)

  • Index Cond: (mkr_person_id = 1)
7. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_part on party stocker (cost=0.29..8.30 rows=1 width=31) (never executed)

  • Index Cond: (location.stocker_part_id = part_id)
8. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=600.20..610.89 rows=1,069 width=8) (never executed)

  • Group Key: balance.loca_id
9. 0.000 0.000 ↓ 0.0 0

Index Scan using fuel_balance_fuel_balance_indx on fuel_balance balance (cost=0.42..588.59 rows=4,645 width=8) (never executed)

  • Index Cond: (fuel_balance > '4'::numeric)
Planning time : 0.678 ms
Execution time : 3.034 ms