explain.depesz.com

PostgreSQL's explain analyze made readable

Result: w2PF : Sft_r_grosspay_only_SubQuery

Settings
# exclusive inclusive rows x rows loops node
1. 181.120 802.352 ↓ 7.3 84,965 1

GroupAggregate (cost=105,623.04..106,203.54 rows=11,610 width=164) (actual time=598.477..802.352 rows=84,965 loops=1)

  • Group Key: fee.ee_id, fenvy.process_date
2. 126.152 621.232 ↓ 7.3 84,965 1

Sort (cost=105,623.04..105,652.06 rows=11,610 width=63) (actual time=598.416..621.232 rows=84,965 loops=1)

  • Sort Key: fee.ee_id, fenvy.process_date
  • Sort Method: external merge Disk: 6376kB
3. 63.229 495.080 ↓ 7.3 84,965 1

Hash Join (cost=10,102.32..104,839.18 rows=11,610 width=63) (actual time=82.452..495.080 rows=84,965 loops=1)

  • Hash Cond: (fenvy.ee_id = fee.ee_id)
4. 355.148 384.859 ↓ 5.4 84,965 1

Bitmap Heap Scan on ft_ee_net_values_ytd fenvy (cost=4,553.09..99,115.19 rows=15,643 width=43) (actual time=35.293..384.859 rows=84,965 loops=1)

  • Recheck Cond: ((ee_er_id = 30) AND ((process_year)::text = ANY ('{20172018,20182019}'::text[])) AND ((ee_pay_freq)::text = 'W'::text))
  • Filter: ((process_date >= '2017-04-06'::date) AND (process_date <= '2018-04-05'::date))
  • Rows Removed by Filter: 48883
  • Heap Blocks: exact=26744
5. 29.711 29.711 ↓ 1.0 133,848 1

Bitmap Index Scan on ft_enetvaly_u2 (cost=0.00..4,549.18 rows=130,267 width=0) (actual time=29.711..29.711 rows=133,848 loops=1)

  • Index Cond: ((ee_er_id = 30) AND ((process_year)::text = ANY ('{20172018,20182019}'::text[])) AND ((ee_pay_freq)::text = 'W'::text))
6. 13.055 46.992 ↑ 1.0 34,526 1

Hash (cost=5,117.16..5,117.16 rows=34,566 width=28) (actual time=46.992..46.992 rows=34,526 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2559kB
7. 33.937 33.937 ↑ 1.0 34,526 1

Seq Scan on ft_employees fee (cost=0.00..5,117.16 rows=34,566 width=28) (actual time=0.025..33.937 rows=34,526 loops=1)

  • Filter: (ee_er_id = 30)
  • Rows Removed by Filter: 12050