explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CNlZ

Settings
# exclusive inclusive rows x rows loops node
1. 13.630 50.146 ↓ 44.0 44 1

Gather (cost=1,001.00..31,559.08 rows=1 width=173) (actual time=44.301..50.146 rows=44 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.251 36.516 ↓ 15.0 15 3 / 3

Nested Loop (cost=1.00..30,558.98 rows=1 width=173) (actual time=33.809..36.516 rows=15 loops=3)

3. 0.080 30.667 ↓ 6.1 622 3 / 3

Nested Loop (cost=0.43..9,554.15 rows=102 width=4) (actual time=24.513..30.667 rows=622 loops=3)

4. 28.582 28.582 ↑ 2.0 1 3 / 3

Parallel Seq Scan on slr_employee (cost=0.00..8,503.51 rows=2 width=4) (actual time=24.452..28.582 rows=1 loops=3)

  • Filter: (candidate_id = 31)
  • Rows Removed by Filter: 113,056
5. 2.005 2.005 ↓ 1.8 622 3 / 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.057..2.005 rows=622 loops=3)

  • Index Cond: (employee_id = slr_employee.id)
6. 5.598 5.598 ↓ 0.0 0 1,866 / 3

Index Scan using slr_taxes_reestr_charge_id on slr_taxes_reestr (cost=0.56..205.92 rows=1 width=173) (actual time=0.009..0.009 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