explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KB2fM

Settings
# exclusive inclusive rows x rows loops node
1. 0.019 0.403 ↓ 44.0 44 1

Nested Loop (cost=0.98..107.14 rows=1 width=173) (actual time=0.281..0.403 rows=44 loops=1)

2. 0.027 0.027 ↑ 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.018..0.027 rows=3 loops=1)

  • Index Cond: (candidate_id = 31)
3. 0.357 0.357 ↓ 7.5 15 3

Index Scan using slr_taxes_reestr_ent_id_2 on slr_taxes_reestr (cost=0.56..13.29 rows=2 width=177) (actual time=0.083..0.119 rows=15 loops=3)

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