explain.depesz.com

PostgreSQL's explain analyze made readable

Result: czH6

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 0.092 ↓ 44.0 44 1

Nested Loop (cost=0.98..793.87 rows=1 width=173) (actual time=0.041..0.092 rows=44 loops=1)

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

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

Index Scan using slr_taxes_reestr_ent_id_2 on slr_taxes_reestr (cost=0.56..127.75 rows=2 width=177) (actual time=0.008..0.020 rows=15 loops=3)

  • Index Cond: ((employee_id = slr_employee.id) AND (period_date >= '2020-05-01'::date) AND (period_date <= '2020-07-30'::date))
  • Filter: ((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: 4