explain.depesz.com

PostgreSQL's explain analyze made readable

Result: slCvb

Settings
# exclusive inclusive rows x rows loops node
1. 0.087 0.563 ↓ 13.0 13 1

GroupAggregate (cost=110.03..110.10 rows=1 width=332) (actual time=0.493..0.563 rows=13 loops=1)

  • Group Key: slr_taxes_reestr.period_date, slr_employee.candidate_id, slr_in_out_charges.funding_source_id
2. 0.063 0.476 ↓ 102.0 102 1

Sort (cost=110.03..110.03 rows=1 width=55) (actual time=0.472..0.476 rows=102 loops=1)

  • Sort Key: slr_taxes_reestr.period_date, slr_in_out_charges.funding_source_id
  • Sort Method: quicksort Memory: 38kB
3. 0.033 0.413 ↓ 102.0 102 1

Nested Loop (cost=1.42..110.02 rows=1 width=55) (actual time=0.038..0.413 rows=102 loops=1)

4. 0.034 0.176 ↓ 102.0 102 1

Nested Loop (cost=0.98..103.17 rows=1 width=55) (actual time=0.030..0.176 rows=102 loops=1)

5. 0.014 0.014 ↑ 1.5 4 1

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

  • Index Cond: (candidate_id = 177,123)
6. 0.128 0.128 ↓ 13.0 26 4

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.009..0.032 rows=26 loops=4)

  • 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.204 0.204 ↑ 1.0 1 102

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.002..0.002 rows=1 loops=102)

  • Index Cond: (id = slr_taxes_reestr.charge_id)