#	exclusive	inclusive	rows x	rows	loops	node
1.	1.151	2519.212	↑ 9.7	10003	1	→ Limit (cost=355891.84..361968.40 rows=97225 width=79) (actual time=2299.918..2519.212 rows=10003 loops=1)
2.	213.090	2518.061	↑ 9.7	10003	1	→ GroupAggregate (cost=355891.84..361968.40 rows=97225 width=79) (actual time=2299.917..2518.061 rows=10003 loops=1)
3.	624.878	2304.971	↑ 1.1	91021	1	→ Sort (cost=355891.84..356134.90 rows=97225 width=79) (actual time=2299.786..2304.971 rows=91021 loops=1) Sort Key: fe.ee_surname, fe.ee_id, fe.ee_wks_no, fe.ee_fname, fe.ee_sfname Sort Method: quicksort Memory: 15872kB
4.	127.435	1680.093	↑ 1.1	91021	1	→ Hash Join (cost=7443.43..347837.22 rows=97225 width=79) (actual time=59.719..1680.093 rows=91021 loops=1) Hash Cond: (fenv.ee_id = fe.ee_id)
5.	1493.201	1493.201	↑ 1.1	101067	1	→ Seq Scan on ft_ee_net_values_ytd fenv (cost=0.00..338161.62 rows=111993 width=63) (actual time=0.208..1493.201 rows=101067 loops=1) Filter: ((ee_er_id = 100) AND ((ee_pay_freq)::text = 'M'::text))
6.	26.613	59.457	↑ 1.0	110005	1	→ Hash (cost=6065.38..6065.38 rows=110244 width=28) (actual time=59.457..59.457 rows=110005 loops=1) Buckets: 16384 Batches: 1 Memory Usage: 6798kB
7.	32.844	32.844	↑ 1.0	110005	1	→ Seq Scan on ft_employees fe (cost=0.00..6065.38 rows=110244 width=28) (actual time=1.029..32.844 rows=110005 loops=1) Filter: (ee_er_id = 100)

Limit  (cost=355891.84..361968.40 rows=97225 width=79) (actual time=2299.918..2519.212 rows=10003 loops=1)

  ->  GroupAggregate  (cost=355891.84..361968.40 rows=97225 width=79) (actual time=2299.917..2518.061 rows=10003 loops=1)

        ->  Sort  (cost=355891.84..356134.90 rows=97225 width=79) (actual time=2299.786..2304.971 rows=91021 loops=1)

              Sort Key: fe.ee_surname, fe.ee_id, fe.ee_wks_no, fe.ee_fname, fe.ee_sfname

              Sort Method: quicksort  Memory: 15872kB

              ->  Hash Join  (cost=7443.43..347837.22 rows=97225 width=79) (actual time=59.719..1680.093 rows=91021 loops=1)

                    Hash Cond: (fenv.ee_id = fe.ee_id)

                    ->  Seq Scan on ft_ee_net_values_ytd fenv  (cost=0.00..338161.62 rows=111993 width=63) (actual time=0.208..1493.201 rows=101067 loops=1)

                          Filter: ((ee_er_id = 100) AND ((ee_pay_freq)::text = 'M'::text))

                    ->  Hash  (cost=6065.38..6065.38 rows=110244 width=28) (actual time=59.457..59.457 rows=110005 loops=1)

                          Buckets: 16384  Batches: 1  Memory Usage: 6798kB

                          ->  Seq Scan on ft_employees fe  (cost=0.00..6065.38 rows=110244 width=28) (actual time=1.029..32.844 rows=110005 loops=1)

                                Filter: (ee_er_id = 100)

Total runtime: 2520.972 ms

Per node type stats

node type	count	sum of times	% of query
GroupAggregate	1	213.090 ms	8.5 %
Hash	1	26.613 ms	1.1 %
Hash Join	1	127.435 ms	5.1 %
Limit	1	1.151 ms	0.0 %
Seq Scan	2	1526.045 ms	60.6 %
Sort	1	624.878 ms	24.8 %

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	1493.201 ms	59.3 %
Seq Scan	1	1493.201 ms	100.0 %
ft_employees	1	32.844 ms	1.3 %
Seq Scan	1	32.844 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 34m : EMPLOYEES & NET VALUES

Colorize:

Columns visibility:

Per node type stats

Per table stats