explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Usuh

Settings
# exclusive inclusive rows x rows loops node
1. 6,064.075 103,792.615 ↓ 3.3 235,656 1

Hash Left Join (cost=96,077.83..40,090,756.99 rows=71,228 width=2,495) (actual time=1,890.517..103,792.615 rows=235,656 loops=1)

  • Hash Cond: ((epv.peo_id = etc.peo_id) AND (epv.employee_type = etc.type_code))
2. 0.000 2,287.809 ↓ 3.4 235,656 1

Gather (cost=96,073.65..1,038,596.69 rows=69,007 width=3,420) (actual time=1,889.392..2,287.809 rows=235,656 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 96.404 5,202.306 ↓ 2.7 78,552 3 / 3

Nested Loop Left Join (cost=95,073.65..1,030,695.99 rows=28,753 width=3,420) (actual time=1,886.935..5,202.306 rows=78,552 loops=3)

4. 148.560 4,398.934 ↓ 2.7 78,552 3 / 3

Nested Loop Left Join (cost=95,073.22..872,969.93 rows=28,753 width=3,427) (actual time=1,886.886..4,398.934 rows=78,552 loops=3)

5. 120.092 3,857.614 ↓ 2.7 78,552 3 / 3

Nested Loop Left Join (cost=95,072.93..860,199.27 rows=28,753 width=2,324) (actual time=1,886.842..3,857.614 rows=78,552 loops=3)

6. 66.680 3,187.658 ↓ 2.7 78,552 3 / 3

Hash Left Join (cost=95,072.51..728,318.15 rows=28,753 width=2,256) (actual time=1,886.793..3,187.658 rows=78,552 loops=3)

  • Hash Cond: ((epv.peo_id = esc.peo_id) AND (epv.employee_status = esc.status_code))
7. 72.157 3,120.872 ↓ 2.7 78,552 3 / 3

Hash Left Join (cost=95,066.66..728,159.30 rows=28,753 width=2,235) (actual time=1,886.656..3,120.872 rows=78,552 loops=3)

  • Hash Cond: ((epv.peo_id = wcc.peo_id) AND (epv.home_wc_class = wcc.class_code) AND (epv.wc_state = wcc.state))
8. 88.452 3,030.053 ↓ 2.7 78,552 3 / 3

Nested Loop Left Join (cost=93,811.30..726,677.51 rows=28,753 width=2,214) (actual time=1,867.686..3,030.053 rows=78,552 loops=3)

9. 61.491 2,863.049 ↓ 2.7 78,552 3 / 3

Hash Left Join (cost=93,810.88..712,880.41 rows=28,753 width=2,208) (actual time=1,867.655..2,863.049 rows=78,552 loops=3)

  • Hash Cond: ((ec.peo_id = div.peo_id) AND (ec.client_id = div.client_id) AND (ec.division_code = div.division_code))
10. 76.556 2,793.063 ↓ 2.7 78,552 3 / 3

Hash Left Join (cost=93,231.52..712,074.63 rows=28,753 width=2,202) (actual time=1,859.066..2,793.063 rows=78,552 loops=3)

  • Hash Cond: ((ec.peo_id = dept.peo_id) AND (ec.client_id = dept.client_id) AND (ec.dept_code = dept.dept_code))
11. 173.427 2,684.333 ↓ 2.7 78,552 3 / 3

Nested Loop Left Join (cost=91,097.23..709,713.91 rows=28,753 width=2,197) (actual time=1,826.668..2,684.333 rows=78,552 loops=3)

12. 544.067 2,039.594 ↓ 2.7 78,552 3 / 3

Parallel Hash Left Join (cost=91,096.80..668,107.69 rows=28,753 width=2,131) (actual time=1,826.604..2,039.594 rows=78,552 loops=3)

  • Hash Cond: ((epv.peo_id = epr.peo_id) AND (epv.employee_id = epr.employee_id))
13. 375.745 1,159.489 ↓ 2.7 78,552 3 / 3

Parallel Hash Left Join (cost=47,820.38..604,543.31 rows=28,753 width=1,959) (actual time=995.644..1,159.489 rows=78,552 loops=3)

  • Hash Cond: ((epv.peo_id = ep.peo_id) AND (epv.client_id = ep.client_id) AND (epv.employee_id = ep.employee_id))
14. 59.438 611.981 ↓ 2.7 78,552 3 / 3

Hash Left Join (cost=5,278.64..546,142.15 rows=28,753 width=1,945) (actual time=48.870..611.981 rows=78,552 loops=3)

  • Hash Cond: ((vt.peo_id = tdc.peo_id) AND (vt.tax_deduction_code = tdc.tax_deduction_code))
15. 58.908 546.169 ↓ 3.6 78,552 3 / 3

Hash Left Join (cost=4,679.82..545,429.02 rows=21,767 width=1,911) (actual time=42.416..546.169 rows=78,552 loops=3)

  • Hash Cond: ((vt.peo_id = tac.peo_id) AND (vt.tax_auth_code = tac.authority_id))
16. 60.276 479.946 ↓ 4.0 78,552 3 / 3

Parallel Hash Left Join (cost=4,065.47..544,712.27 rows=19,502 width=1,884) (actual time=34.999..479.946 rows=78,552 loops=3)

  • Hash Cond: ((epv.peo_id = lc.peo_id) AND (epv.client_id = lc.client_id) AND (epv.home_location = lc.location_code))
17. 62.155 409.042 ↓ 4.0 78,552 3 / 3

Parallel Hash Left Join (cost=2,508.52..543,001.73 rows=19,502 width=1,845) (actual time=24.177..409.042 rows=78,552 loops=3)

  • Hash Cond: ((epv.peo_id = jc.peo_id) AND (epv.client_id = jc.client_id) AND (epv.home_job = jc.job_code))
18. 53.696 325.469 ↓ 4.0 78,552 3 / 3

Hash Left Join (cost=252.13..540,591.76 rows=19,502 width=1,807) (actual time=2.565..325.469 rows=78,552 loops=3)

  • Hash Cond: ((epv.peo_id = em.peo_id) AND (epv.employer_id = em.employer_id))
19. 38.818 269.580 ↓ 4.0 78,552 3 / 3

Hash Left Join (cost=12.15..540,249.39 rows=19,502 width=1,350) (actual time=0.342..269.580 rows=78,552 loops=3)

  • Hash Cond: ((epv.peo_id = cfe.peo_id) AND (epv.entity_id = cfe.entity_id))
20. 57.164 230.594 ↓ 4.0 78,552 3 / 3

Nested Loop (cost=1.00..540,135.85 rows=19,502 width=1,290) (actual time=0.153..230.594 rows=78,552 loops=3)

21. 12.974 12.974 ↑ 2.3 13,371 3 / 3

Parallel Index Scan using idx_epv_pay_date on epv (cost=0.43..287,752.32 rows=30,495 width=1,182) (actual time=0.098..12.974 rows=13,371 loops=3)

  • Index Cond: ((pay_date >= '2019-01-01'::date) AND (pay_date < '2019-01-07'::date))
  • Filter: (status = 'PRNT'::text)
22. 160.456 160.456 ↓ 6.0 6 40,114 / 3

Index Scan using pk_inf_emptax_comtax_rollup on inf_emptax_comtax_rollup vt (cost=0.57..8.27 rows=1 width=108) (actual time=0.010..0.012 rows=6 loops=40,114)

  • Index Cond: ((peo_id = epv.peo_id) AND (client_id = epv.client_id) AND (voucher_number = epv.voucher_id))
23. 0.063 0.168 ↑ 1.0 246 3 / 3

Hash (cost=7.46..7.46 rows=246 width=71) (actual time=0.168..0.168 rows=246 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 33kB
24. 0.105 0.105 ↑ 1.0 246 3 / 3

Seq Scan on client_federal_entities cfe (cost=0.00..7.46 rows=246 width=71) (actual time=0.064..0.105 rows=246 loops=3)

25. 1.282 2.193 ↑ 1.0 2,504 3 / 3

Hash (cost=201.59..201.59 rows=2,559 width=467) (actual time=2.193..2.193 rows=2,504 loops=3)

  • Buckets: 4096 Batches: 1 Memory Usage: 1245kB
26. 0.911 0.911 ↑ 1.0 2,504 3 / 3

Seq Scan on employer_master em (cost=0.00..201.59 rows=2,559 width=467) (actual time=0.008..0.911 rows=2,504 loops=3)

27. 15.089 21.418 ↑ 1.8 24,783 3 / 3

Parallel Hash (cost=1,484.87..1,484.87 rows=44,087 width=52) (actual time=21.417..21.418 rows=24,783 loops=3)

  • Buckets: 131072 Batches: 1 Memory Usage: 6784kB
28. 6.329 6.329 ↑ 1.8 24,783 3 / 3

Parallel Seq Scan on job_codes jc (cost=0.00..1,484.87 rows=44,087 width=52) (actual time=0.008..6.329 rows=24,783 loops=3)

29. 6.430 10.628 ↑ 1.8 10,691 3 / 3

Parallel Hash (cost=1,226.71..1,226.71 rows=18,871 width=51) (actual time=10.628..10.628 rows=10,691 loops=3)

  • Buckets: 32768 Batches: 1 Memory Usage: 2432kB
30. 4.198 4.198 ↑ 1.8 10,691 3 / 3

Parallel Seq Scan on location_codes lc (cost=0.00..1,226.71 rows=18,871 width=51) (actual time=0.007..4.198 rows=10,691 loops=3)

31. 4.470 7.315 ↓ 1.0 16,503 3 / 3

Hash (cost=366.94..366.94 rows=16,494 width=40) (actual time=7.315..7.315 rows=16,503 loops=3)

  • Buckets: 32768 Batches: 1 Memory Usage: 1350kB
32. 2.845 2.845 ↓ 1.0 16,503 3 / 3

Seq Scan on tax_auth_codes tac (cost=0.00..366.94 rows=16,494 width=40) (actual time=0.040..2.845 rows=16,503 loops=3)

33. 3.877 6.374 ↓ 1.0 16,048 3 / 3

Hash (cost=358.33..358.33 rows=16,033 width=49) (actual time=6.374..6.374 rows=16,048 loops=3)

  • Buckets: 16384 Batches: 1 Memory Usage: 1229kB
34. 2.497 2.497 ↓ 1.0 16,048 3 / 3

Seq Scan on tax_dedn_codes tdc (cost=0.00..358.33 rows=16,033 width=49) (actual time=0.036..2.497 rows=16,048 loops=3)

35. 59.503 171.763 ↑ 1.3 206,004 3 / 3

Parallel Hash (cost=36,273.54..36,273.54 rows=257,554 width=30) (actual time=171.763..171.763 rows=206,004 loops=3)

  • Buckets: 65536 Batches: 16 Memory Usage: 3040kB
36. 112.260 112.260 ↑ 1.3 206,004 3 / 3

Parallel Seq Scan on employee_pay ep (cost=0.00..36,273.54 rows=257,554 width=30) (actual time=0.009..112.260 rows=206,004 loops=3)

37. 98.782 336.038 ↑ 1.2 195,694 3 / 3

Parallel Hash (cost=33,399.37..33,399.37 rows=244,537 width=183) (actual time=336.037..336.038 rows=195,694 loops=3)

  • Buckets: 32768 Batches: 64 Memory Usage: 1632kB
38. 237.256 237.256 ↑ 1.2 195,694 3 / 3

Parallel Seq Scan on employee_per epr (cost=0.00..33,399.37 rows=244,537 width=183) (actual time=0.023..237.256 rows=195,694 loops=3)

39. 471.312 471.312 ↑ 1.0 1 235,656 / 3

Index Scan using pk_employee_com on employee_com ec (cost=0.42..1.45 rows=1 width=73) (actual time=0.006..0.006 rows=1 loops=235,656)

  • Index Cond: ((epv.peo_id = peo_id) AND (epv.client_id = client_id) AND (epv.employee_id = employee_id))
40. 20.044 32.174 ↑ 1.0 52,665 3 / 3

Hash (cost=1,197.38..1,197.38 rows=53,538 width=25) (actual time=32.174..32.174 rows=52,665 loops=3)

  • Buckets: 65536 Batches: 1 Memory Usage: 3558kB
41. 12.130 12.130 ↑ 1.0 52,665 3 / 3

Seq Scan on dept_codes dept (cost=0.00..1,197.38 rows=53,538 width=25) (actual time=0.030..12.130 rows=52,665 loops=3)

42. 5.214 8.495 ↑ 1.0 15,152 3 / 3

Hash (cost=311.22..311.22 rows=15,322 width=24) (actual time=8.495..8.495 rows=15,152 loops=3)

  • Buckets: 16384 Batches: 1 Memory Usage: 993kB
43. 3.281 3.281 ↑ 1.0 15,152 3 / 3

Seq Scan on division_codes div (cost=0.00..311.22 rows=15,322 width=24) (actual time=0.028..3.281 rows=15,152 loops=3)

44. 78.552 78.552 ↓ 0.0 0 235,656 / 3

Index Scan using pk_proj_work_codes on proj_work_codes pwc (cost=0.42..0.48 rows=1 width=40) (actual time=0.001..0.001 rows=0 loops=235,656)

  • Index Cond: ((ec.peo_id = peo_id) AND (ec.client_id = client_id) AND (ec.proj_workord = work_code))
45. 11.676 18.662 ↑ 1.0 32,813 3 / 3

Hash (cost=681.13..681.13 rows=32,813 width=36) (actual time=18.662..18.662 rows=32,813 loops=3)

  • Buckets: 65536 Batches: 1 Memory Usage: 2788kB
46. 6.986 6.986 ↑ 1.0 32,813 3 / 3

Seq Scan on wc_class_codes wcc (cost=0.00..681.13 rows=32,813 width=36) (actual time=0.018..6.986 rows=32,813 loops=3)

47. 0.056 0.106 ↑ 1.0 154 3 / 3

Hash (cost=3.54..3.54 rows=154 width=30) (actual time=0.106..0.106 rows=154 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
48. 0.050 0.050 ↑ 1.0 154 3 / 3

Seq Scan on employee_status_codes esc (cost=0.00..3.54 rows=154 width=30) (actual time=0.021..0.050 rows=154 loops=3)

49. 549.864 549.864 ↑ 1.0 1 235,656 / 3

Index Scan using pk_batch_control on batch_control bc (cost=0.43..4.59 rows=1 width=82) (actual time=0.007..0.007 rows=1 loops=235,656)

  • Index Cond: ((epv.peo_id = peo_id) AND (epv.client_id = client_id) AND (epv.batch_no = batch_no))
50. 392.760 392.760 ↑ 1.0 1 235,656 / 3

Index Scan using pk_client_master on client_master cm (cost=0.29..0.44 rows=1 width=1,111) (actual time=0.005..0.005 rows=1 loops=235,656)

  • Index Cond: ((epv.peo_id = peo_id) AND (epv.client_id = client_id))
51. 706.968 706.968 ↑ 1.0 1 235,656 / 3

Index Scan using pk_inf_hours_worked on inf_hours_worked_agg tav (cost=0.43..5.49 rows=1 width=20) (actual time=0.009..0.009 rows=1 loops=235,656)

  • Index Cond: ((epv.peo_id = peo_id) AND (epv.client_id = client_id) AND (epv.voucher_id = voucher_id))
52. 0.031 0.051 ↓ 1.5 127 1

Hash (cost=2.87..2.87 rows=87 width=28) (actual time=0.051..0.051 rows=127 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
53. 0.020 0.020 ↓ 1.5 127 1

Seq Scan on employee_type_codes etc (cost=0.00..2.87 rows=87 width=28) (actual time=0.004..0.020 rows=127 loops=1)

54.          

SubPlan (for Hash Left Join)

55. 0.000 5,184.432 ↓ 0.0 0 235,656

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.022..0.022 rows=0 loops=235,656)

56. 5,184.432 5,184.432 ↓ 0.0 0 235,656

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.022..0.022 rows=0 loops=235,656)

57. 0.000 0.000 ↑ 1.0 1 235,656

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=235,656)

58. 706.968 3,299.184 ↓ 0.0 0 235,656

Hash Join (cost=36.11..249.65 rows=21 width=21) (actual time=0.014..0.014 rows=0 loops=235,656)

  • Hash Cond: (tdc_1.tax_deduction_code = (jsonb_extract_path_text((jsonb_array_elements((epv.record -> 'taxrecalc'::text))), VARIADIC '{comTaxRecalcCode}'::text[])))
59. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on tax_dedn_codes tdc_1 (cost=31.59..241.38 rows=943 width=31) (never executed)

  • Recheck Cond: (epv.peo_id = peo_id)
60. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on pk_tax_dedn_codes (cost=0.00..31.36 rows=943 width=0) (never executed)

  • Index Cond: (epv.peo_id = peo_id)
61. 0.000 2,592.216 ↓ 0.0 0 235,656

Hash (cost=3.27..3.27 rows=100 width=32) (actual time=0.011..0.011 rows=0 loops=235,656)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
62. 0.000 2,592.216 ↓ 0.0 0 235,656

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.011..0.011 rows=0 loops=235,656)

63. 2,592.216 2,592.216 ↓ 0.0 0 235,656

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.011..0.011 rows=0 loops=235,656)

64. 0.000 0.000 ↑ 1.0 1 235,656

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=235,656)

65. 0.000 2,356.560 ↓ 0.0 0 235,656

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.010..0.010 rows=0 loops=235,656)

66. 2,356.560 2,356.560 ↓ 0.0 0 235,656

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.010..0.010 rows=0 loops=235,656)

67. 0.000 0.000 ↑ 1.0 1 235,656

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=235,656)

68. 235.656 2,356.560 ↓ 0.0 0 235,656

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.010..0.010 rows=0 loops=235,656)

69. 2,120.904 2,120.904 ↓ 0.0 0 235,656

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.009..0.009 rows=0 loops=235,656)

70. 0.000 0.000 ↑ 1.0 1 235,656

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=235,656)

71. 0.000 2,120.904 ↓ 0.0 0 235,656

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.009..0.009 rows=0 loops=235,656)

72. 2,120.904 2,120.904 ↓ 0.0 0 235,656

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.009..0.009 rows=0 loops=235,656)

73. 0.000 0.000 ↑ 1.0 1 235,656

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=235,656)

74. 235.656 2,827.872 ↑ 50.0 2 235,656

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.011..0.012 rows=2 loops=235,656)

75. 2,592.216 2,592.216 ↑ 50.0 2 235,656

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.011..0.011 rows=2 loops=235,656)

76. 0.000 0.000 ↑ 1.0 1 235,656

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=235,656)

77. 706.968 3,534.840 ↓ 0.0 0 235,656

Hash Join (cost=36.33..254.44 rows=35 width=15) (actual time=0.015..0.015 rows=0 loops=235,656)

  • Hash Cond: (tac_1.authority_id = (jsonb_extract_path_text((jsonb_array_elements((epv.record -> 'taxfile'::text))), VARIADIC '{taxAuthCode}'::text[])))
78. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on tax_auth_codes tac_1 (cost=31.80..245.93 rows=970 width=23) (never executed)

  • Recheck Cond: (epv.peo_id = peo_id)
79. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on pk_tax_auth_codes (cost=0.00..31.56 rows=970 width=0) (never executed)

  • Index Cond: (epv.peo_id = peo_id)
80. 235.656 2,827.872 ↓ 0.0 0 235,656

Hash (cost=3.27..3.27 rows=100 width=32) (actual time=0.012..0.012 rows=0 loops=235,656)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
81. 0.000 2,592.216 ↑ 50.0 2 235,656

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.011..0.011 rows=2 loops=235,656)

82. 2,592.216 2,592.216 ↑ 50.0 2 235,656

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.010..0.011 rows=2 loops=235,656)

83. 0.000 0.000 ↑ 1.0 1 235,656

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=235,656)

84. 235.656 2,356.560 ↑ 50.0 2 235,656

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.009..0.010 rows=2 loops=235,656)

85. 2,120.904 2,120.904 ↑ 50.0 2 235,656

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.009..0.009 rows=2 loops=235,656)

86. 0.000 0.000 ↑ 1.0 1 235,656

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=235,656)

87. 235.656 2,356.560 ↑ 50.0 2 235,656

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.009..0.010 rows=2 loops=235,656)

88. 2,120.904 2,120.904 ↑ 50.0 2 235,656

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.009..0.009 rows=2 loops=235,656)

89. 0.000 0.000 ↑ 1.0 1 235,656

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=235,656)

90. 0.000 2,120.904 ↑ 50.0 2 235,656

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.009..0.009 rows=2 loops=235,656)

91. 2,120.904 2,120.904 ↑ 50.0 2 235,656

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.009..0.009 rows=2 loops=235,656)

92. 0.000 0.000 ↑ 1.0 1 235,656

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=235,656)

93. 0.000 2,120.904 ↑ 50.0 2 235,656

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.009..0.009 rows=2 loops=235,656)

94. 2,120.904 2,120.904 ↑ 50.0 2 235,656

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.008..0.009 rows=2 loops=235,656)

95. 0.000 0.000 ↑ 1.0 1 235,656

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=235,656)

96. 0.000 0.000 ↓ 0.0 0 235,656

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.000..0.000 rows=0 loops=235,656)

97. 0.000 0.000 ↑ 1.0 1 235,656

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=235,656)

98. 0.000 0.000 ↓ 0.0 0 235,656

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.000..0.000 rows=0 loops=235,656)

99. 0.000 0.000 ↑ 1.0 1 235,656

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=235,656)

100. 1,885.248 16,024.608 ↑ 2.4 42 235,656

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.056..0.068 rows=42 loops=235,656)

101. 14,139.360 14,139.360 ↑ 2.4 42 235,656

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.056..0.060 rows=42 loops=235,656)

102. 0.000 0.000 ↑ 1.0 1 235,656

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=235,656)

103. 2,120.904 14,139.360 ↑ 2.4 42 235,656

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.048..0.060 rows=42 loops=235,656)

104. 12,018.456 12,018.456 ↑ 2.4 42 235,656

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.048..0.051 rows=42 loops=235,656)

105. 0.000 0.000 ↑ 1.0 1 235,656

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=235,656)

106. 2,120.904 13,903.704 ↑ 2.4 42 235,656

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.047..0.059 rows=42 loops=235,656)

107. 11,782.800 11,782.800 ↑ 2.4 42 235,656

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.047..0.050 rows=42 loops=235,656)

108. 0.000 0.000 ↑ 1.0 1 235,656

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=235,656)

109. 235.656 3,534.840 ↑ 33.3 3 235,656

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.014..0.015 rows=3 loops=235,656)

110. 3,299.184 3,299.184 ↑ 33.3 3 235,656

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.014..0.014 rows=3 loops=235,656)

111. 0.000 0.000 ↑ 1.0 1 235,656

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=235,656)

112. 235.656 3,299.184 ↑ 33.3 3 235,656

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.013..0.014 rows=3 loops=235,656)

113. 3,063.528 3,063.528 ↑ 33.3 3 235,656

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.012..0.013 rows=3 loops=235,656)

114. 0.000 0.000 ↑ 1.0 1 235,656

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=235,656)

115. 235.656 3,063.528 ↑ 33.3 3 235,656

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.012..0.013 rows=3 loops=235,656)

116. 2,827.872 2,827.872 ↑ 33.3 3 235,656

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.011..0.012 rows=3 loops=235,656)

117. 0.000 0.000 ↑ 1.0 1 235,656

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=235,656)

118. 235.656 2,827.872 ↑ 33.3 3 235,656

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.011..0.012 rows=3 loops=235,656)

119. 2,592.216 2,592.216 ↑ 33.3 3 235,656

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.011..0.011 rows=3 loops=235,656)

120. 0.000 0.000 ↑ 1.0 1 235,656

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=235,656)

121. 235.656 2,827.872 ↑ 33.3 3 235,656

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.011..0.012 rows=3 loops=235,656)

122. 2,592.216 2,592.216 ↑ 33.3 3 235,656

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.011..0.011 rows=3 loops=235,656)

123. 0.000 0.000 ↑ 1.0 1 235,656

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=235,656)

124. 0.000 2,592.216 ↑ 33.3 3 235,656

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.011..0.011 rows=3 loops=235,656)

125. 2,592.216 2,592.216 ↑ 33.3 3 235,656

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.010..0.011 rows=3 loops=235,656)

126. 0.000 0.000 ↑ 1.0 1 235,656

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=235,656)

127. 235.656 2,592.216 ↑ 33.3 3 235,656

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.010..0.011 rows=3 loops=235,656)

128. 2,356.560 2,356.560 ↑ 33.3 3 235,656

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.010..0.010 rows=3 loops=235,656)

129. 0.000 0.000 ↑ 1.0 1 235,656

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=235,656)

Planning time : 38.578 ms
Execution time : 104,811.642 ms