explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Axnp

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 1,347.895 ↓ 0.0 0 1

Unique (cost=29,293.59..29,293.60 rows=1 width=8) (actual time=1,347.894..1,347.895 rows=0 loops=1)

2. 0.145 1,347.894 ↓ 0.0 0 1

Sort (cost=29,293.59..29,293.60 rows=1 width=8) (actual time=1,347.894..1,347.894 rows=0 loops=1)

  • Sort Key: slr_taxes_reestr.calc_order
  • Sort Method: quicksort Memory: 25kB
3. 0.002 1,347.749 ↓ 0.0 0 1

Nested Loop (cost=1.14..29,293.58 rows=1 width=8) (actual time=1,347.749..1,347.749 rows=0 loops=1)

4. 1,347.747 1,347.747 ↓ 0.0 0 1

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

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

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

  • Index Cond: (id = slr_taxes_reestr.charge_id)
  • Filter: (employee_id = 651479)
Planning time : 38.137 ms
Execution time : 1,347.977 ms