explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Pylb

Settings
# exclusive inclusive rows x rows loops node
1. 5,369.315 128,791.433 ↓ 36.0 1,034,943 1

Gather (cost=1,342,579.54..1,427,238.66 rows=28,784 width=2,966) (actual time=108,914.946..128,791.433 rows=1,034,943 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 1,134.391 123,422.118 ↓ 28.8 344,981 3 / 3

Nested Loop Left Join (cost=1,341,579.54..1,423,360.26 rows=11,993 width=2,966) (actual time=108,776.476..123,422.118 rows=344,981 loops=3)

3. 708.311 114,008.183 ↓ 28.8 344,981 3 / 3

Merge Left Join (cost=1,341,579.10..1,341,806.44 rows=11,993 width=2,948) (actual time=108,775.034..114,008.183 rows=344,981 loops=3)

  • Merge Cond: ((epv.client_id = e4kl.client_id) AND (epv.employee_id = e4kl.employee_id))
  • Join Filter: (epv.peo_id = e4kl.peo_id)
4. 649.510 113,290.658 ↓ 27.7 332,098 3 / 3

Merge Left Join (cost=1,341,547.27..1,341,713.34 rows=11,993 width=2,898) (actual time=108,768.971..113,290.658 rows=332,098 loops=3)

  • Merge Cond: ((epv.client_id = e4kp.client_id) AND (epv.employee_id = e4kp.employee_id))
  • Join Filter: (epv.peo_id = e4kp.peo_id)
5. 1,565.552 112,634.201 ↓ 27.7 332,098 3 / 3

Merge Left Join (cost=1,341,409.74..1,341,509.37 rows=11,993 width=2,782) (actual time=108,762.320..112,634.201 rows=332,098 loops=3)

  • Merge Cond: ((epv.client_id = e4kd.client_id) AND (epv.employee_id = e4kd.employee_id))
  • Join Filter: ((epv.pay_date >= e4kd.effective_date) AND (epv.peo_id = e4kd.peo_id))
  • Rows Removed by Join Filter: 32040
6. 21,487.369 111,054.612 ↓ 26.4 316,171 3 / 3

Sort (cost=1,341,223.89..1,341,253.88 rows=11,993 width=2,724) (actual time=108,759.143..111,054.612 rows=316,171 loops=3)

  • Sort Key: epv.client_id, epv.employee_id
  • Sort Method: external merge Disk: 302280kB
  • Worker 0: Sort Method: external merge Disk: 298400kB
  • Worker 1: Sort Method: external merge Disk: 296024kB
7. 415.491 89,567.243 ↓ 26.4 316,171 3 / 3

Hash Left Join (cost=104,520.29..1,326,309.87 rows=11,993 width=2,724) (actual time=8,091.614..89,567.243 rows=316,171 loops=3)

  • Hash Cond: ((epv.peo_id = pyxref.peo_id) AND (epv.retire_plan = pyxref.plan_id))
8. 507.390 89,148.171 ↓ 26.4 316,171 3 / 3

Hash Left Join (cost=104,512.12..1,326,211.36 rows=11,993 width=2,596) (actual time=8,087.473..89,148.171 rows=316,171 loops=3)

  • Hash Cond: ((epv.peo_id = jobc.peo_id) AND (epv.client_id = jobc.client_id) AND (epv.home_job = jobc.job_code))
9. 454.283 88,639.276 ↓ 26.4 316,171 3 / 3

Hash Left Join (cost=104,122.94..1,325,727.74 rows=11,993 width=2,524) (actual time=8,085.929..88,639.276 rows=316,171 loops=3)

  • Hash Cond: ((epv.peo_id = em.peo_id) AND (epv.employer_id = em.employer_id))
10. 386.356 88,184.906 ↓ 26.4 316,171 3 / 3

Hash Left Join (cost=104,110.55..1,325,650.69 rows=11,993 width=2,422) (actual time=8,085.814..88,184.906 rows=316,171 loops=3)

  • Hash Cond: ((cm.peo_id = cfe.peo_id) AND (cm.entity_id = cfe.entity_id))
11. 510.805 87,798.533 ↓ 26.4 316,171 3 / 3

Hash Join (cost=104,102.37..1,325,579.55 rows=11,993 width=2,365) (actual time=8,085.770..87,798.533 rows=316,171 loops=3)

  • Hash Cond: (epv.client_id = cm.client_id)
12. 486.629 87,285.090 ↓ 6.3 317,976 3 / 3

Parallel Hash Left Join (cost=103,744.25..1,325,088.59 rows=50,428 width=1,988) (actual time=8,082.828..87,285.090 rows=317,976 loops=3)

  • Hash Cond: ((epv.peo_id = bc.peo_id) AND (epv.client_id = bc.client_id) AND (epv.batch_no = bc.batch_no))
13. 338.728 86,704.769 ↓ 6.3 317,976 3 / 3

Hash Left Join (cost=70,738.83..1,291,686.05 rows=50,428 width=1,902) (actual time=7,988.888..86,704.769 rows=317,976 loops=3)

  • Hash Cond: ((epv.peo_id = unionc.peo_id) AND (epv.client_id = unionc.client_id) AND (epv.union_code = unionc.union_code))
14. 411.338 86,365.984 ↓ 6.3 317,976 3 / 3

Hash Left Join (cost=70,729.62..1,291,279.69 rows=50,428 width=1,884) (actual time=7,988.803..86,365.984 rows=317,976 loops=3)

  • Hash Cond: ((epv.peo_id = wcclassc.peo_id) AND (epv.home_wc_class = wcclassc.class_code) AND (epv.wc_state = wcclassc.state))
15. 380.371 85,948.995 ↓ 6.3 317,976 3 / 3

Hash Left Join (cost=70,450.78..1,290,603.72 rows=50,428 width=1,843) (actual time=7,983.126..85,948.995 rows=317,976 loops=3)

  • Hash Cond: ((epv.peo_id = etc.peo_id) AND (epv.employee_type = etc.type_code))
16. 424.679 85,568.596 ↓ 6.3 317,976 3 / 3

Hash Left Join (cost=70,442.61..1,290,327.75 rows=50,428 width=1,779) (actual time=7,983.071..85,568.596 rows=317,976 loops=3)

  • Hash Cond: ((epv.peo_id = locc.peo_id) AND (epv.client_id = locc.client_id) AND (epv.home_location = locc.location_code))
17. 322.276 85,143.422 ↓ 6.3 317,976 3 / 3

Hash Left Join (cost=70,190.24..1,289,677.81 rows=50,428 width=1,637) (actual time=7,982.548..85,143.422 rows=317,976 loops=3)

  • Hash Cond: ((epv.peo_id = projc.peo_id) AND (epv.client_id = projc.client_id) AND (epv.home_project = projc.work_code))
18. 348.788 84,816.262 ↓ 6.3 317,976 3 / 3

Hash Left Join (cost=70,057.47..1,289,147.93 rows=50,428 width=1,622) (actual time=7,977.634..84,816.262 rows=317,976 loops=3)

  • Hash Cond: ((epv.peo_id = divc.peo_id) AND (epv.client_id = divc.client_id) AND (epv.home_division = divc.division_code))
19. 402.416 84,467.270 ↓ 6.3 317,976 3 / 3

Hash Left Join (cost=70,041.03..1,288,734.36 rows=50,428 width=1,607) (actual time=7,977.403..84,467.270 rows=317,976 loops=3)

  • Hash Cond: ((epvtsearn.peo_id = earnc.peo_id) AND (epvtsearn.ts_earn_code = earnc.pay_code))
20. 741.713 84,064.602 ↓ 6.3 317,976 3 / 3

Nested Loop Left Join (cost=69,964.60..1,288,390.31 rows=50,428 width=1,614) (actual time=7,977.112..84,064.602 rows=317,976 loops=3)

21. 266.546 66,783.337 ↓ 4.7 204,192 3 / 3

Hash Left Join (cost=69,964.04..974,137.68 rows=43,612 width=1,603) (actual time=7,973.149..66,783.337 rows=204,192 loops=3)

  • Hash Cond: ((epv.peo_id = deptc.peo_id) AND (epv.client_id = deptc.client_id) AND (epv.home_department = deptc.dept_code))
22. 257.976 66,515.142 ↓ 4.7 204,192 3 / 3

Hash Left Join (cost=69,707.98..973,538.18 rows=43,612 width=1,591) (actual time=7,970.967..66,515.142 rows=204,192 loops=3)

  • Hash Cond: ((epv.peo_id = esc.peo_id) AND (epv.employee_status = esc.status_code))
23. 375.395 66,257.039 ↓ 4.7 204,192 3 / 3

Parallel Hash Left Join (cost=69,699.81..973,298.75 rows=43,612 width=1,495) (actual time=7,970.685..66,257.039 rows=204,192 loops=3)

  • Hash Cond: ((epv.peo_id = ecom.peo_id) AND (epv.client_id = ecom.client_id) AND (epv.employee_id = ecom.employee_id))
24. 359.844 65,826.691 ↓ 4.7 204,192 3 / 3

Parallel Hash Left Join (cost=62,133.75..965,389.24 rows=43,612 width=1,432) (actual time=7,915.407..65,826.691 rows=204,192 loops=3)

  • Hash Cond: ((epv.peo_id = epay.peo_id) AND (epv.client_id = epay.client_id) AND (epv.employee_id = epay.employee_id))
25. 486.956 65,417.902 ↓ 4.7 204,192 3 / 3

Parallel Hash Join (cost=50,661.37..953,573.42 rows=43,612 width=1,418) (actual time=7,866.235..65,417.902 rows=204,192 loops=3)

  • Hash Cond: (epv.employee_id = eper.employee_id)
26. 62,257.072 64,847.515 ↑ 1.3 204,195 3 / 3

Parallel Bitmap Heap Scan on epv (cost=32,819.80..935,051.73 rows=259,090 width=1,239) (actual time=7,782.608..64,847.515 rows=204,195 loops=3)

  • Recheck Cond: (peo_id = 'imp.delta'::text)
  • Rows Removed by Index Recheck: 7930
  • Filter: (status = 'PRNT'::text)
  • Heap Blocks: exact=11637 lossy=22216
27. 2,590.443 2,590.443 ↑ 1.0 612,590 1 / 3

Bitmap Index Scan on pk_epv (cost=0.00..32,664.34 rows=621,838 width=0) (actual time=7,771.328..7,771.328 rows=612,590 loops=1)

  • Index Cond: (peo_id = 'imp.delta'::text)
28. 14.784 83.431 ↑ 1.9 6,813 3 / 3

Parallel Hash (cost=17,683.43..17,683.43 rows=12,651 width=192) (actual time=83.430..83.431 rows=6,813 loops=3)

  • Buckets: 32768 Batches: 1 Memory Usage: 2752kB
29. 68.647 68.647 ↑ 1.9 6,813 3 / 3

Parallel Seq Scan on employee_per eper (cost=0.00..17,683.43 rows=12,651 width=192) (actual time=0.011..68.647 rows=6,813 loops=3)

  • Filter: (peo_id = 'imp.delta'::text)
  • Rows Removed by Filter: 84650
30. 8.062 48.945 ↑ 1.3 7,043 3 / 3

Parallel Hash (cost=11,315.75..11,315.75 rows=8,950 width=33) (actual time=48.945..48.945 rows=7,043 loops=3)

  • Buckets: 32768 Batches: 1 Memory Usage: 1760kB
31. 34.733 40.883 ↑ 1.3 7,043 3 / 3

Parallel Bitmap Heap Scan on employee_pay epay (cost=746.88..11,315.75 rows=8,950 width=33) (actual time=19.112..40.883 rows=7,043 loops=3)

  • Recheck Cond: (peo_id = 'imp.delta'::text)
  • Heap Blocks: exact=548
32. 6.150 6.150 ↓ 1.0 21,530 1 / 3

Bitmap Index Scan on pk_employee_pay (cost=0.00..741.51 rows=21,479 width=0) (actual time=18.450..18.450 rows=21,530 loops=1)

  • Index Cond: (peo_id = 'imp.delta'::text)
33. 7.662 54.953 ↑ 1.3 7,047 3 / 3

Parallel Hash (cost=7,404.15..7,404.15 rows=9,252 width=82) (actual time=54.953..54.953 rows=7,047 loops=3)

  • Buckets: 32768 Batches: 1 Memory Usage: 1984kB
34. 33.899 47.291 ↑ 1.3 7,047 3 / 3

Parallel Bitmap Heap Scan on employee_com ecom (cost=812.50..7,404.15 rows=9,252 width=82) (actual time=40.528..47.291 rows=7,047 loops=3)

  • Recheck Cond: (peo_id = 'imp.delta'::text)
  • Heap Blocks: exact=112
35. 13.392 13.392 ↑ 1.0 21,150 1 / 3

Bitmap Index Scan on pk_employee_com (cost=0.00..806.95 rows=22,204 width=0) (actual time=40.177..40.177 rows=21,150 loops=1)

  • Index Cond: (peo_id = 'imp.delta'::text)
36. 0.006 0.127 ↓ 5.0 5 3 / 3

Hash (cost=8.16..8.16 rows=1 width=160) (actual time=0.127..0.127 rows=5 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
37. 0.121 0.121 ↓ 5.0 5 3 / 3

Index Scan using pk_employee_status_codes on employee_status_codes esc (cost=0.14..8.16 rows=1 width=160) (actual time=0.118..0.121 rows=5 loops=3)

  • Index Cond: (peo_id = 'imp.delta'::text)
38. 0.403 1.649 ↑ 1.0 1,292 3 / 3

Hash (cost=233.45..233.45 rows=1,292 width=29) (actual time=1.649..1.649 rows=1,292 loops=3)

  • Buckets: 2048 Batches: 1 Memory Usage: 103kB
39. 0.257 1.246 ↑ 1.0 1,292 3 / 3

Bitmap Heap Scan on dept_codes deptc (cost=42.30..233.45 rows=1,292 width=29) (actual time=1.001..1.246 rows=1,292 loops=3)

  • Recheck Cond: (peo_id = 'imp.delta'::text)
  • Heap Blocks: exact=15
40. 0.989 0.989 ↑ 1.0 1,292 3 / 3

Bitmap Index Scan on pk_dept_codes (cost=0.00..41.97 rows=1,292 width=0) (actual time=0.989..0.989 rows=1,292 loops=3)

  • Index Cond: (peo_id = 'imp.delta'::text)
41. 16,539.552 16,539.552 ↑ 1.0 1 612,576 / 3

Index Scan using pk_epv_tsearn on epv_tsearn epvtsearn (cost=0.56..7.20 rows=1 width=23) (actual time=0.065..0.081 rows=1 loops=612,576)

  • Index Cond: ((epv.peo_id = peo_id) AND (peo_id = 'imp.delta'::text) AND (epv.client_id = client_id) AND (epv.voucher_id = voucher_id))
42. 0.056 0.252 ↑ 1.0 176 3 / 3

Hash (cost=73.79..73.79 rows=176 width=18) (actual time=0.252..0.252 rows=176 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
43. 0.196 0.196 ↑ 1.0 176 3 / 3

Seq Scan on earning_codes earnc (cost=0.00..73.79 rows=176 width=18) (actual time=0.010..0.196 rows=176 loops=3)

  • Filter: (peo_id = 'imp.delta'::text)
  • Rows Removed by Filter: 447
44. 0.092 0.204 ↑ 1.0 219 3 / 3

Hash (cost=12.61..12.61 rows=219 width=34) (actual time=0.204..0.204 rows=219 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 23kB
45. 0.112 0.112 ↑ 1.0 219 3 / 3

Seq Scan on division_codes divc (cost=0.00..12.61 rows=219 width=34) (actual time=0.015..0.112 rows=219 loops=3)

  • Filter: (peo_id = 'imp.delta'::text)
  • Rows Removed by Filter: 310
46. 0.041 4.884 ↓ 1.0 79 3 / 3

Hash (cost=131.40..131.40 rows=78 width=39) (actual time=4.883..4.884 rows=79 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
47. 4.843 4.843 ↓ 1.0 79 3 / 3

Index Scan using pk_proj_work_codes on proj_work_codes projc (cost=0.29..131.40 rows=78 width=39) (actual time=3.246..4.843 rows=79 loops=3)

  • Index Cond: (peo_id = 'imp.delta'::text)
48. 0.205 0.495 ↑ 1.0 479 3 / 3

Hash (cost=243.98..243.98 rows=479 width=162) (actual time=0.495..0.495 rows=479 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 40kB
49. 0.238 0.290 ↑ 1.0 479 3 / 3

Bitmap Heap Scan on location_codes locc (cost=20.00..243.98 rows=479 width=162) (actual time=0.061..0.290 rows=479 loops=3)

  • Recheck Cond: (peo_id = 'imp.delta'::text)
  • Heap Blocks: exact=9
50. 0.052 0.052 ↑ 1.0 479 3 / 3

Bitmap Index Scan on pk_location_codes (cost=0.00..19.88 rows=479 width=0) (actual time=0.052..0.052 rows=479 loops=3)

  • Index Cond: (peo_id = 'imp.delta'::text)
51. 0.005 0.028 ↓ 6.0 6 3 / 3

Hash (cost=8.16..8.16 rows=1 width=128) (actual time=0.028..0.028 rows=6 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
52. 0.023 0.023 ↓ 6.0 6 3 / 3

Index Scan using pk_employee_type_codes on employee_type_codes etc (cost=0.14..8.16 rows=1 width=128) (actual time=0.021..0.023 rows=6 loops=3)

  • Index Cond: (peo_id = 'imp.delta'::text)
53. 0.080 5.651 ↑ 1.0 192 3 / 3

Hash (cost=275.47..275.47 rows=192 width=52) (actual time=5.650..5.651 rows=192 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
54. 0.054 5.571 ↑ 1.0 192 3 / 3

Bitmap Heap Scan on wc_class_codes wcclassc (cost=5.78..275.47 rows=192 width=52) (actual time=5.530..5.571 rows=192 loops=3)

  • Recheck Cond: (peo_id = 'imp.delta'::text)
  • Heap Blocks: exact=2
55. 5.517 5.517 ↑ 1.0 192 3 / 3

Bitmap Index Scan on pk_wc_class_codes (cost=0.00..5.73 rows=192 width=0) (actual time=5.517..5.517 rows=192 loops=3)

  • Index Cond: (peo_id = 'imp.delta'::text)
56. 0.008 0.057 ↑ 1.0 16 3 / 3

Hash (cost=8.94..8.94 rows=16 width=42) (actual time=0.057..0.057 rows=16 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
57. 0.049 0.049 ↑ 1.0 16 3 / 3

Seq Scan on union_codes unionc (cost=0.00..8.94 rows=16 width=42) (actual time=0.014..0.049 rows=16 loops=3)

  • Filter: (peo_id = 'imp.delta'::text)
  • Rows Removed by Filter: 219
58. 18.800 93.692 ↑ 1.2 12,579 3 / 3

Parallel Hash (cost=32,733.11..32,733.11 rows=15,560 width=105) (actual time=93.692..93.692 rows=12,579 loops=3)

  • Buckets: 65536 Batches: 1 Memory Usage: 4448kB
59. 74.892 74.892 ↑ 1.2 12,579 3 / 3

Parallel Seq Scan on batch_control bc (cost=0.00..32,733.11 rows=15,560 width=105) (actual time=35.985..74.892 rows=12,579 loops=3)

  • Filter: (peo_id = 'imp.delta'::text)
  • Rows Removed by Filter: 36717
60. 0.235 2.638 ↑ 1.0 286 3 / 3

Hash (cost=354.55..354.55 rows=286 width=382) (actual time=2.638..2.638 rows=286 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 76kB
61. 2.403 2.403 ↑ 1.0 286 3 / 3

Seq Scan on client_master cm (cost=0.00..354.55 rows=286 width=382) (actual time=0.019..2.403 rows=286 loops=3)

  • Filter: (peo_id = 'imp.delta'::text)
  • Rows Removed by Filter: 1518
62. 0.000 0.017 ↓ 0.0 0 3 / 3

Hash (cost=8.16..8.16 rows=1 width=128) (actual time=0.017..0.017 rows=0 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
63. 0.017 0.017 ↓ 0.0 0 3 / 3

Index Scan using pk_client_federal_entities on client_federal_entities cfe (cost=0.14..8.16 rows=1 width=128) (actual time=0.016..0.017 rows=0 loops=3)

  • Index Cond: (peo_id = 'imp.delta'::text)
64. 0.035 0.087 ↑ 1.1 78 3 / 3

Hash (cost=11.09..11.09 rows=87 width=115) (actual time=0.087..0.087 rows=78 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
65. 0.052 0.052 ↑ 1.1 78 3 / 3

Seq Scan on employer_master em (cost=0.00..11.09 rows=87 width=115) (actual time=0.008..0.052 rows=78 loops=3)

  • Filter: (peo_id = 'imp.delta'::text)
  • Rows Removed by Filter: 14
66. 0.683 1.505 ↑ 1.0 1,719 3 / 3

Hash (cost=359.10..359.10 rows=1,719 width=98) (actual time=1.505..1.505 rows=1,719 loops=3)

  • Buckets: 2048 Batches: 1 Memory Usage: 127kB
67. 0.686 0.822 ↑ 1.0 1,719 3 / 3

Bitmap Heap Scan on job_codes jobc (cost=69.61..359.10 rows=1,719 width=98) (actual time=0.147..0.822 rows=1,719 loops=3)

  • Recheck Cond: (peo_id = 'imp.delta'::text)
  • Heap Blocks: exact=30
68. 0.136 0.136 ↑ 1.0 1,719 3 / 3

Bitmap Index Scan on pk_job_codes (cost=0.00..69.18 rows=1,719 width=0) (actual time=0.136..0.136 rows=1,719 loops=3)

  • Index Cond: (peo_id = 'imp.delta'::text)
69. 0.014 3.581 ↓ 16.0 16 3 / 3

Hash (cost=8.16..8.16 rows=1 width=192) (actual time=3.581..3.581 rows=16 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
70. 3.567 3.567 ↓ 16.0 16 3 / 3

Index Scan using pk_plan_year_xref on plan_year_xref pyxref (cost=0.14..8.16 rows=1 width=192) (actual time=2.062..3.567 rows=16 loops=3)

  • Index Cond: (peo_id = 'imp.delta'::text)
71. 13.361 14.037 ↓ 68.6 88,158 3 / 3

Sort (cost=185.84..189.05 rows=1,285 width=78) (actual time=3.148..14.037 rows=88,158 loops=3)

  • Sort Key: e4kd.client_id, e4kd.employee_id
  • Sort Method: quicksort Memory: 156kB
  • Worker 0: Sort Method: quicksort Memory: 156kB
  • Worker 1: Sort Method: quicksort Memory: 156kB
72. 0.676 0.676 ↑ 1.0 1,285 3 / 3

Seq Scan on employee_401k_detail e4kd (cost=0.00..119.49 rows=1,285 width=78) (actual time=0.039..0.676 rows=1,285 loops=3)

  • Filter: (peo_id = 'imp.delta'::text)
  • Rows Removed by Filter: 3714
73. 2.805 6.947 ↑ 1.0 859 3 / 3

Sort (cost=137.54..139.68 rows=859 width=136) (actual time=6.631..6.947 rows=859 loops=3)

  • Sort Key: e4kp.client_id, e4kp.employee_id
  • Sort Method: quicksort Memory: 125kB
  • Worker 0: Sort Method: quicksort Memory: 125kB
  • Worker 1: Sort Method: quicksort Memory: 125kB
74. 0.253 4.142 ↑ 1.0 859 3 / 3

Bitmap Heap Scan on employee_401k_plans e4kp (cost=30.94..95.67 rows=859 width=136) (actual time=3.903..4.142 rows=859 loops=3)

  • Recheck Cond: (peo_id = 'imp.delta'::text)
  • Heap Blocks: exact=13
75. 3.889 3.889 ↑ 1.0 859 3 / 3

Bitmap Index Scan on pk_employee_401k_plans (cost=0.00..30.72 rows=859 width=0) (actual time=3.889..3.889 rows=859 loops=3)

  • Index Cond: (peo_id = 'imp.delta'::text)
76. 3.477 9.214 ↓ 159.2 27,549 3 / 3

Sort (cost=31.83..32.26 rows=173 width=70) (actual time=6.046..9.214 rows=27,549 loops=3)

  • Sort Key: e4kl.client_id, e4kl.employee_id
  • Sort Method: quicksort Memory: 49kB
  • Worker 0: Sort Method: quicksort Memory: 49kB
  • Worker 1: Sort Method: quicksort Memory: 49kB
77. 5.737 5.737 ↑ 1.0 173 3 / 3

Seq Scan on employee_401k_loans e4kl (cost=0.00..25.40 rows=173 width=70) (actual time=1.305..5.737 rows=173 loops=3)

  • Filter: (peo_id = 'imp.delta'::text)
  • Rows Removed by Filter: 659
78. 8,279.544 8,279.544 ↑ 1.0 1 1,034,943 / 3

Index Scan using pk_inf_hours_worked on inf_hours_worked_agg ihwa (cost=0.43..6.80 rows=1 width=30) (actual time=0.024..0.024 rows=1 loops=1,034,943)

  • Index Cond: ((epv.peo_id = peo_id) AND (peo_id = 'imp.delta'::text) AND (epv.client_id = client_id) AND (epv.voucher_id = voucher_id))