explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 34m : EMPLOYEES & NET VALUES

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 1.151 2,519.212 ↑ 9.7 10,003 1

Limit (cost=355,891.84..361,968.40 rows=97,225 width=79) (actual time=2,299.918..2,519.212 rows=10,003 loops=1)

2. 213.090 2,518.061 ↑ 9.7 10,003 1

GroupAggregate (cost=355,891.84..361,968.40 rows=97,225 width=79) (actual time=2,299.917..2,518.061 rows=10,003 loops=1)

3. 624.878 2,304.971 ↑ 1.1 91,021 1

Sort (cost=355,891.84..356,134.90 rows=97,225 width=79) (actual time=2,299.786..2,304.971 rows=91,021 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 1,680.093 ↑ 1.1 91,021 1

Hash Join (cost=7,443.43..347,837.22 rows=97,225 width=79) (actual time=59.719..1,680.093 rows=91,021 loops=1)

  • Hash Cond: (fenv.ee_id = fe.ee_id)
5. 1,493.201 1,493.201 ↑ 1.1 101,067 1

Seq Scan on ft_ee_net_values_ytd fenv (cost=0.00..338,161.62 rows=111,993 width=63) (actual time=0.208..1,493.201 rows=101,067 loops=1)

  • Filter: ((ee_er_id = 100) AND ((ee_pay_freq)::text = 'M'::text))
6. 26.613 59.457 ↑ 1.0 110,005 1

Hash (cost=6,065.38..6,065.38 rows=110,244 width=28) (actual time=59.457..59.457 rows=110,005 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 6798kB
7. 32.844 32.844 ↑ 1.0 110,005 1

Seq Scan on ft_employees fe (cost=0.00..6,065.38 rows=110,244 width=28) (actual time=1.029..32.844 rows=110,005 loops=1)

  • Filter: (ee_er_id = 100)