explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vsl2

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 9.653 ↓ 22.0 44 1

Nested Loop (cost=1.42..7,564.17 rows=2 width=173) (actual time=9.435..9.653 rows=44 loops=1)

2. 0.191 2.719 ↓ 7.6 1,866 1

Nested Loop (cost=0.86..3,179.20 rows=245 width=4) (actual time=0.053..2.719 rows=1,866 loops=1)

3. 0.044 0.044 ↑ 2.0 3 1

Index Scan using slr_employee_candidate_id on slr_employee (cost=0.42..27.26 rows=6 width=4) (actual time=0.029..0.044 rows=3 loops=1)

  • Index Cond: (candidate_id = 31)
4. 2.484 2.484 ↓ 1.8 622 3

Index Scan using slr_in_out_charges_employee_id on slr_in_out_charges (cost=0.43..521.78 rows=354 width=8) (actual time=0.020..0.828 rows=622 loops=3)

  • Index Cond: (employee_id = slr_employee.id)
5. 7.464 7.464 ↓ 0.0 0 1,866

Index Scan using slr_taxes_reestr_charge_id on slr_taxes_reestr (cost=0.56..17.89 rows=1 width=173) (actual time=0.003..0.004 rows=0 loops=1,866)

  • Index Cond: (charge_id = slr_in_out_charges.id)
  • Filter: ((period_date >= '2020-05-01'::date) AND (period_date <= '2020-07-30'::date) AND (ent_id = 1,500) AND (tax_id = ANY ('{7,1,2,3,4,5,8,9,10,11,12,13,14,15}'::integer[])))
  • Rows Removed by Filter: 2