explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7fDw

Settings
# exclusive inclusive rows x rows loops node
1. 10.724 42.881 ↓ 44.0 44 1

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

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.259 32.157 ↓ 15.0 15 3 / 3

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

3. 0.077 27.544 ↓ 6.1 622 3 / 3

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

4. 25.571 25.571 ↑ 2.0 1 3 / 3

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

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

  • Index Cond: (employee_id = slr_employee.id)
6. 4.354 4.354 ↓ 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.007..0.007 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