#	exclusive	inclusive	rows x	rows	loops	node
1.	0.763	51.697	↓ 2000.0	2000	1	→ Nested Loop (cost=11.47..24.48 rows=1 width=1006) (actual time=13.832..51.697 rows=2000 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	↓ 2000.0	2000	1	→ HashAggregate (cost=9.20..9.21 rows=1 width=145) (actual time=13.751..16.928 rows=2000 loops=1)
6.	1.112	1.112	↓ 2000.0	2000	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=2000 loops=1) Index Cond: ((ee_er_id = 266) AND ((process_year)::text = '20092010'::text))
7.	6.000	6.000	↑ 1.0	1	2000	→ 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=2000) 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	2000	→ Hash Join (cost=1.15..4.69 rows=1 width=2) (actual time=0.010..0.014 rows=1 loops=2000) Hash Cond: (fnc.ni_taxyear_id = fst.taxyear_id)
10.	22.000	22.000	↓ 1.1	12	2000	→ 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=2000) 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)

Nested Loop  (cost=11.47..24.48 rows=1 width=1006) (actual time=13.832..51.697 rows=2000 loops=1)

  InitPlan 2 (returns $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)

  InitPlan 3 (returns $2)

    ->  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)

  ->  HashAggregate  (cost=9.20..9.21 rows=1 width=145) (actual time=13.751..16.928 rows=2000 loops=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=2000 loops=1)

              Index Cond: ((ee_er_id = 266) AND ((process_year)::text = '20092010'::text))

  ->  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=2000)

        Index Cond: (ee_id = feeytd.ee_id)

        Filter: (((ee_sys_status)::text <> 'D'::text) AND (ee_er_id = 266))

  SubPlan 1

    ->  Hash Join  (cost=1.15..4.69 rows=1 width=2) (actual time=0.010..0.014 rows=1 loops=2000)

          Hash Cond: (fnc.ni_taxyear_id = fst.taxyear_id)

          ->  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=2000)

                Filter: (ni_cat_id = fee.ee_ni_cat_id)

          ->  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

                ->  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)

Per node type stats

node type	count	sum of times	% of query
Hash	1	0.001 ms	0.0 %
Hash Join	1	5.993 ms	11.6 %
HashAggregate	1	15.816 ms	30.6 %
Index Scan	2	7.112 ms	13.8 %
Nested Loop	1	0.763 ms	1.5 %
Seq Scan	4	22.012 ms	42.6 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
ft_ee_net_values_ytd	1	1.112 ms	2.2 %
Index Scan	1	1.112 ms	100.0 %
ft_employees	1	6.000 ms	11.6 %
Index Scan	1	6.000 ms	100.0 %
ft_ni_cat	1	22.000 ms	42.6 %
Seq Scan	1	22.000 ms	100.0 %
ft_sys_taxyear	3	0.012 ms	0.0 %
Seq Scan	3	0.012 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: pji : ABLEDB

Colorize:

Columns visibility:

Per node type stats

Per table stats