explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QFfy : Optimization for: plan #GIr

Settings

Optimization path:

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

Unique (cost=29,293.58..29,293.59 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=29,293.58..29,293.59 rows=1 width=8) (actual rows= loops=)

  • Sort Key: slr_taxes_reestr.calc_order
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.14..29,293.57 rows=1 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Scan using slr_taxes_reestr_ent_id_6a7234caa3746c2b on slr_taxes_reestr (cost=0.57..29,290.78 rows=1 width=12) (actual rows= loops=)

  • Index Cond: ((ent_id = 4248) AND (period_date >= '2018-04-01'::date) AND (period_date < '2018-04-30'::date))
  • Filter: (calc_type <> 1)
5. 0.000 0.000 ↓ 0.0

Index Scan using slr_in_out_charges_pkey on slr_in_out_charges (cost=0.57..2.79 rows=1 width=12) (actual rows= loops=)

  • Index Cond: (id = slr_taxes_reestr.charge_id)
  • Filter: (employee_id = 651479)