explain.depesz.com

PostgreSQL's explain analyze made readable

Result: E1fQ

Settings
# exclusive inclusive rows x rows loops node
1. 9.402 60.508 ↓ 22.0 44 1

Hash Join (cost=4,089.29..365,891.83 rows=2 width=173) (actual time=22.020..60.508 rows=44 loops=1)

  • Hash Cond: (slr_taxes_reestr.employee_id = slr_employee.id)
2. 44.040 51.051 ↑ 3.2 38,270 1

Bitmap Heap Scan on slr_taxes_reestr (cost=4,061.96..365,542.61 rows=122,625 width=177) (actual time=7.980..51.051 rows=38,270 loops=1)

  • Recheck Cond: ((ent_id = 1,500) AND (tax_id = ANY ('{7,1,2,3,4,5,8,9,10,11,12,13,14,15}'::integer[])) AND (period_date >= '2020-05-01'::date) AND (period_date <= '2020-07-30'::date))
  • Heap Blocks: exact=6,551
3. 7.011 7.011 ↑ 1.6 74,358 1

Bitmap Index Scan on slr_taxes_reestr_ent_id_6a7234caa3746c2b (cost=0.00..4,031.30 rows=122,625 width=0) (actual time=7.011..7.011 rows=74,358 loops=1)

  • Index Cond: ((ent_id = 1,500) AND (tax_id = ANY ('{7,1,2,3,4,5,8,9,10,11,12,13,14,15}'::integer[])) AND (period_date >= '2020-05-01'::date) AND (period_date <= '2020-07-30'::date))
4. 0.003 0.055 ↑ 2.0 3 1

Hash (cost=27.26..27.26 rows=6 width=4) (actual time=0.055..0.055 rows=3 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
5. 0.052 0.052 ↑ 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.038..0.052 rows=3 loops=1)

  • Index Cond: (candidate_id = 31)