explain.depesz.com

A tool for finding a real cause for slow queries.

Result: pji : ABLEDB

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.763 51.697 ↓ 2,000.0 2,000 1

Nested Loop (cost=11.47..24.48 rows=1 width=1,006) (actual time=13.832..51.697 rows=2,000 loops=1)

2.          

Initplan (forNested Loop)

3. 0.003 0.003 ↑ 1.0 1 1

Seq Scan on ft_sys_taxyear fst (cost=0.00..1.14 rows=1 width=4) (actual time=0.002..0.003 rows=1 loops=1)

  • Filter: ((taxyear)::text = '20092010'::text)
4. 0.003 0.003 ↑ 1.0 1 1

Seq Scan on ft_sys_taxyear fst (cost=0.00..1.14 rows=1 width=4) (actual time=0.002..0.003 rows=1 loops=1)

  • Filter: ((taxyear)::text = '20092010'::text)
5. 15.816 16.928 ↓ 2,000.0 2,000 1

HashAggregate (cost=9.20..9.21 rows=1 width=145) (actual time=13.751..16.928 rows=2,000 loops=1)

6. 1.112 1.112 ↓ 2,000.0 2,000 1

Index Scan using ft_enetvaly_u2 on ft_ee_net_values_ytd feeytd (cost=0.00..9.09 rows=1 width=145) (actual time=0.074..1.112 rows=2,000 loops=1)

  • Index Cond: ((ee_er_id = 266) AND ((process_year)::text = '20092010'::text))
7. 6.000 6.000 ↑ 1.0 1 2,000

Index Scan using ft_ee_p on ft_employees fee (cost=0.00..8.29 rows=1 width=118) (actual time=0.002..0.003 rows=1 loops=2,000)

  • Index Cond: (ee_id = feeytd.ee_id)
  • Filter: (((ee_sys_status)::text <> 'D'::text) AND (ee_er_id = 266))
8.          

SubPlan (forNested Loop)

9. 5.993 28.000 ↑ 1.0 1 2,000

Hash Join (cost=1.15..4.69 rows=1 width=2) (actual time=0.010..0.014 rows=1 loops=2,000)

  • Hash Cond: (fnc.ni_taxyear_id = fst.taxyear_id)
10. 22.000 22.000 ↓ 1.1 12 2,000

Seq Scan on ft_ni_cat fnc (cost=0.00..3.49 rows=11 width=6) (actual time=0.001..0.011 rows=12 loops=2,000)

  • Filter: (ni_cat_id = fee.ee_ni_cat_id)
11. 0.001 0.007 ↑ 1.0 1 1

Hash (cost=1.14..1.14 rows=1 width=4) (actual time=0.007..0.007 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
12. 0.006 0.006 ↑ 1.0 1 1

Seq Scan on ft_sys_taxyear fst (cost=0.00..1.14 rows=1 width=4) (actual time=0.005..0.006 rows=1 loops=1)

  • Filter: ((taxyear)::text = '20092010'::text)