explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XI8x

Settings
# exclusive inclusive rows x rows loops node
1. 0.031 0.160 ↓ 6.0 6 1

GroupAggregate (cost=110.03..110.10 rows=1 width=332) (actual time=0.141..0.160 rows=6 loops=1)

  • Group Key: slr_taxes_reestr.period_date, slr_employee.candidate_id, slr_in_out_charges.funding_source_id
2. 0.015 0.129 ↓ 19.0 19 1

Sort (cost=110.03..110.03 rows=1 width=55) (actual time=0.128..0.129 rows=19 loops=1)

  • Sort Key: slr_taxes_reestr.period_date, slr_in_out_charges.funding_source_id
  • Sort Method: quicksort Memory: 27kB
3. 0.007 0.114 ↓ 19.0 19 1

Nested Loop (cost=1.42..110.02 rows=1 width=55) (actual time=0.034..0.114 rows=19 loops=1)

4. 0.008 0.050 ↓ 19.0 19 1

Nested Loop (cost=0.98..103.17 rows=1 width=55) (actual time=0.025..0.050 rows=19 loops=1)

5. 0.009 0.009 ↑ 6.0 1 1

Index Scan using slr_employee_candidate_id on slr_employee (cost=0.42..27.26 rows=6 width=8) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: (candidate_id = 9,543)
6. 0.033 0.033 ↓ 9.5 19 1

Index Scan using slr_taxes_reestr_ent_id_2 on slr_taxes_reestr (cost=0.56..12.63 rows=2 width=55) (actual time=0.014..0.033 rows=19 loops=1)

  • Index Cond: ((employee_id = slr_employee.id) AND (ent_id = 1,500) AND (period_date >= '2020-01-01'::date) AND (period_date <= '2020-07-01'::date) AND (tax_id = 6))
7. 0.057 0.057 ↑ 1.0 1 19

Index Scan using slr_in_out_charges_pkey on slr_in_out_charges (cost=0.43..6.85 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=19)

  • Index Cond: (id = slr_taxes_reestr.charge_id)