explain.depesz.com

PostgreSQL's explain analyze made readable

Result: owSU

Settings
# exclusive inclusive rows x rows loops node
1. 2,327.900 58,536.822 ↑ 10.8 94,577 1

Gather (cost=220,562.20..46,379,357.93 rows=1,019,496 width=2,986) (actual time=9,282.617..58,536.822 rows=94,577 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 77.996 11,190.270 ↑ 13.5 31,526 3 / 3

Hash Left Join (cost=219,562.20..1,235,075.05 rows=424,790 width=4,098) (actual time=9,933.237..11,190.270 rows=31,526 loops=3)

  • Hash Cond: ((epv.peo_id = cm.peo_id) AND (epv.client_id = cm.client_id))
3. 48.740 11,100.868 ↑ 13.5 31,526 3 / 3

Hash Left Join (cost=219,185.10..1,232,465.97 rows=424,790 width=3,018) (actual time=9,921.800..11,100.868 rows=31,526 loops=3)

  • Hash Cond: ((epv.peo_id = etc.peo_id) AND (epv.employee_type = etc.type_code))
4. 51.926 11,052.103 ↑ 13.5 31,526 3 / 3

Hash Left Join (cost=219,171.85..1,230,222.38 rows=424,790 width=2,954) (actual time=9,921.753..11,052.103 rows=31,526 loops=3)

  • Hash Cond: ((epv.peo_id = esc.peo_id) AND (epv.employee_status = esc.status_code))
5. 2,085.148 11,000.144 ↑ 13.5 31,526 3 / 3

Parallel Hash Left Join (cost=219,158.10..1,227,978.33 rows=424,790 width=2,890) (actual time=9,921.684..11,000.144 rows=31,526 loops=3)

  • Hash Cond: ((epv.peo_id = tav.peo_id) AND (epv.client_id = tav.client_id) AND (epv.voucher_id = tav.voucher_id))
6. 709.988 6,424.109 ↑ 8.3 31,526 3 / 3

Parallel Hash Left Join (cost=86,828.46..889,833.29 rows=262,020 width=2,892) (actual time=6,004.274..6,424.109 rows=31,526 loops=3)

  • Hash Cond: ((epv.peo_id = bc.peo_id) AND (epv.client_id = bc.client_id) AND (epv.batch_no = bc.batch_no))
7. 57.605 5,543.082 ↑ 8.3 31,526 3 / 3

Hash Left Join (cost=52,310.81..670,694.22 rows=262,020 width=2,815) (actual time=4,108.482..5,543.082 rows=31,526 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. 59.890 5,458.027 ↑ 8.3 31,526 3 / 3

Hash Left Join (cost=51,404.01..667,723.98 rows=262,020 width=2,779) (actual time=4,080.840..5,458.027 rows=31,526 loops=3)

  • Hash Cond: ((ec.peo_id = pwc.peo_id) AND (ec.client_id = pwc.client_id) AND (ec.proj_workord = pwc.work_code))
9. 61.430 5,374.023 ↑ 8.3 31,526 3 / 3

Hash Left Join (cost=50,490.20..664,746.76 rows=262,020 width=2,786) (actual time=4,056.580..5,374.023 rows=31,526 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. 53.780 5,312.199 ↑ 8.3 31,526 3 / 3

Hash Left Join (cost=50,469.65..662,662.78 rows=262,020 width=2,775) (actual time=4,056.158..5,312.199 rows=31,526 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. 1,563.001 5,247.465 ↑ 8.3 31,526 3 / 3

Parallel Hash Left Join (cost=49,956.51..660,086.21 rows=262,020 width=2,767) (actual time=4,045.153..5,247.465 rows=31,526 loops=3)

  • Hash Cond: ((epv.peo_id = epr.peo_id) AND (epv.employee_id = epr.employee_id))
12. 1,648.276 3,457.770 ↑ 8.3 31,526 3 / 3

Parallel Hash Left Join (cost=27,706.64..466,492.72 rows=262,020 width=2,580) (actual time=2,164.490..3,457.770 rows=31,526 loops=3)

  • Hash Cond: ((epv.peo_id = ec.peo_id) AND (epv.client_id = ec.client_id) AND (epv.employee_id = ec.employee_id))
13. 530.440 1,578.724 ↑ 8.3 31,526 3 / 3

Parallel Hash Left Join (cost=16,491.20..289,488.87 rows=262,020 width=2,511) (actual time=1,291.878..1,578.724 rows=31,526 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. 62.626 770.698 ↑ 8.3 31,526 3 / 3

Hash Left Join (cost=1,879.86..110,178.12 rows=262,020 width=2,497) (actual time=72.411..770.698 rows=31,526 loops=3)

  • Hash Cond: ((epv.peo_id = lc.peo_id) AND (epv.client_id = lc.client_id) AND (epv.home_location = lc.location_code))
15. 51.502 692.968 ↑ 3.5 31,526 3 / 3

Hash Left Join (cost=1,399.04..108,827.28 rows=110,434 width=2,372) (actual time=57.222..692.968 rows=31,526 loops=3)

  • Hash Cond: ((vt.peo_id = tdc.peo_id) AND (vt.tax_deduction_code = tdc.tax_deduction_code))
16. 97.503 637.474 ↑ 3.0 31,526 3 / 3

Hash Left Join (cost=1,247.52..108,186.99 rows=93,032 width=2,336) (actual time=53.184..637.474 rows=31,526 loops=3)

  • Hash Cond: ((vt.peo_id = tac.peo_id) AND (vt.tax_auth_code = tac.authority_id))
17. 75.716 534.564 ↑ 2.7 31,526 3 / 3

Hash Left Join (cost=1,107.09..107,592.34 rows=86,460 width=2,309) (actual time=47.727..534.564 rows=31,526 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. 43.911 415.663 ↑ 2.7 31,526 3 / 3

Hash Left Join (cost=343.24..106,147.62 rows=86,460 width=2,221) (actual time=4.368..415.663 rows=31,526 loops=3)

  • Hash Cond: ((epv.peo_id = em.peo_id) AND (epv.employer_id = em.employer_id))
19. 37.501 371.609 ↑ 2.7 31,526 3 / 3

Hash Left Join (cost=331.07..105,680.59 rows=86,460 width=1,426) (actual time=4.207..371.609 rows=31,526 loops=3)

  • Hash Cond: ((epv.peo_id = cfe.peo_id) AND (epv.entity_id = cfe.entity_id))
20. 89.256 334.096 ↑ 2.7 31,526 3 / 3

Nested Loop (cost=315.82..105,211.42 rows=86,460 width=1,330) (actual time=4.173..334.096 rows=31,526 loops=3)

21. 17.101 17.678 ↓ 1.1 6,490 3 / 3

Parallel Bitmap Heap Scan on epv (cost=315.25..53,226.83 rows=6,131 width=1,219) (actual time=2.652..17.678 rows=6,490 loops=3)

  • Recheck Cond: ((pay_date >= '2019-01-01'::date) AND (pay_date < '2019-01-07'::date))
  • Filter: (status = 'PRNT'::text)
  • Heap Blocks: exact=836
22. 0.577 0.577 ↓ 1.3 19,471 1 / 3

Bitmap Index Scan on idx_epv_pay_date (cost=0.00..311.57 rows=14,714 width=0) (actual time=1.731..1.731 rows=19,471 loops=1)

  • Index Cond: ((pay_date >= '2019-01-01'::date) AND (pay_date < '2019-01-07'::date))
23. 227.162 227.162 ↓ 5.0 5 19,471 / 3

Index Scan using pk_inf_emptax_comtax_rollup on inf_emptax_comtax_rollup vt (cost=0.56..8.47 rows=1 width=111) (actual time=0.032..0.035 rows=5 loops=19,471)

  • Index Cond: ((peo_id = epv.peo_id) AND (client_id = epv.client_id) AND (voucher_number = epv.voucher_id))
24. 0.001 0.012 ↓ 0.0 0 3 / 3

Hash (cost=12.10..12.10 rows=210 width=160) (actual time=0.012..0.012 rows=0 loops=3)

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

Seq Scan on client_federal_entities cfe (cost=0.00..12.10 rows=210 width=160) (actual time=0.011..0.011 rows=0 loops=3)

26. 0.071 0.143 ↓ 1.1 92 3 / 3

Hash (cost=10.87..10.87 rows=87 width=808) (actual time=0.143..0.143 rows=92 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 74kB
27. 0.072 0.072 ↓ 1.1 92 3 / 3

Seq Scan on employer_master em (cost=0.00..10.87 rows=87 width=808) (actual time=0.010..0.072 rows=92 loops=3)

28. 23.247 43.185 ↑ 1.0 18,031 3 / 3

Hash (cost=448.31..448.31 rows=18,031 width=114) (actual time=43.185..43.185 rows=18,031 loops=3)

  • Buckets: 32768 Batches: 1 Memory Usage: 1814kB
29. 19.938 19.938 ↑ 1.0 18,031 3 / 3

Seq Scan on job_codes jc (cost=0.00..448.31 rows=18,031 width=114) (actual time=0.009..19.938 rows=18,031 loops=3)

30. 2.924 5.407 ↑ 1.0 3,737 3 / 3

Hash (cost=84.37..84.37 rows=3,737 width=42) (actual time=5.407..5.407 rows=3,737 loops=3)

  • Buckets: 4096 Batches: 1 Memory Usage: 288kB
31. 2.483 2.483 ↑ 1.0 3,737 3 / 3

Seq Scan on tax_auth_codes tac (cost=0.00..84.37 rows=3,737 width=42) (actual time=0.017..2.483 rows=3,737 loops=3)

32. 2.899 3.992 ↑ 1.0 3,981 3 / 3

Hash (cost=91.81..91.81 rows=3,981 width=55) (actual time=3.992..3.992 rows=3,981 loops=3)

  • Buckets: 4096 Batches: 1 Memory Usage: 328kB
33. 1.093 1.093 ↑ 1.0 3,981 3 / 3

Seq Scan on tax_dedn_codes tdc (cost=0.00..91.81 rows=3,981 width=55) (actual time=0.014..1.093 rows=3,981 loops=3)

34. 9.166 15.104 ↑ 1.0 9,557 3 / 3

Hash (cost=313.57..313.57 rows=9,557 width=145) (actual time=15.104..15.104 rows=9,557 loops=3)

  • Buckets: 16384 Batches: 1 Memory Usage: 905kB
35. 5.938 5.938 ↑ 1.0 9,557 3 / 3

Seq Scan on location_codes lc (cost=0.00..313.57 rows=9,557 width=145) (actual time=0.013..5.938 rows=9,557 loops=3)

36. 117.410 277.586 ↑ 1.3 94,094 3 / 3

Parallel Hash (cost=11,631.85..11,631.85 rows=117,685 width=33) (actual time=277.586..277.586 rows=94,094 loops=3)

  • Buckets: 65536 Batches: 8 Memory Usage: 2976kB
37. 160.176 160.176 ↑ 1.3 94,094 3 / 3

Parallel Seq Scan on employee_pay ep (cost=0.00..11,631.85 rows=117,685 width=33) (actual time=0.008..160.176 rows=94,094 loops=3)

38. 105.590 230.770 ↑ 1.3 94,101 3 / 3

Parallel Hash (cost=7,655.07..7,655.07 rows=117,907 width=76) (actual time=230.770..230.770 rows=94,101 loops=3)

  • Buckets: 65536 Batches: 16 Memory Usage: 2336kB
39. 125.180 125.180 ↑ 1.3 94,101 3 / 3

Parallel Seq Scan on employee_com ec (cost=0.00..7,655.07 rows=117,907 width=76) (actual time=0.012..125.180 rows=94,101 loops=3)

40. 114.745 226.694 ↑ 1.3 91,463 3 / 3

Parallel Hash (cost=17,396.95..17,396.95 rows=114,595 width=200) (actual time=226.694..226.694 rows=91,463 loops=3)

  • Buckets: 32768 Batches: 32 Memory Usage: 1472kB
41. 111.949 111.949 ↑ 1.3 91,463 3 / 3

Parallel Seq Scan on employee_per epr (cost=0.00..17,396.95 rows=114,595 width=200) (actual time=0.008..111.949 rows=91,463 loops=3)

42. 6.150 10.954 ↑ 1.0 12,296 3 / 3

Hash (cost=297.96..297.96 rows=12,296 width=29) (actual time=10.954..10.954 rows=12,296 loops=3)

  • Buckets: 16384 Batches: 1 Memory Usage: 895kB
43. 4.804 4.804 ↑ 1.0 12,296 3 / 3

Seq Scan on dept_codes dept (cost=0.00..297.96 rows=12,296 width=29) (actual time=0.031..4.804 rows=12,296 loops=3)

44. 0.239 0.394 ↑ 1.0 529 3 / 3

Hash (cost=11.29..11.29 rows=529 width=34) (actual time=0.393..0.394 rows=529 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 44kB
45. 0.155 0.155 ↑ 1.0 529 3 / 3

Seq Scan on division_codes div (cost=0.00..11.29 rows=529 width=34) (actual time=0.016..0.155 rows=529 loops=3)

46. 15.762 24.114 ↓ 1.0 22,176 3 / 3

Hash (cost=525.75..525.75 rows=22,175 width=39) (actual time=24.114..24.114 rows=22,176 loops=3)

  • Buckets: 32768 Batches: 1 Memory Usage: 1828kB
47. 8.352 8.352 ↓ 1.0 22,176 3 / 3

Seq Scan on proj_work_codes pwc (cost=0.00..525.75 rows=22,175 width=39) (actual time=0.014..8.352 rows=22,176 loops=3)

48. 18.274 27.450 ↑ 1.0 22,720 3 / 3

Hash (cost=509.20..509.20 rows=22,720 width=52) (actual time=27.450..27.450 rows=22,720 loops=3)

  • Buckets: 32768 Batches: 1 Memory Usage: 2148kB
49. 9.176 9.176 ↑ 1.0 22,720 3 / 3

Seq Scan on wc_class_codes wcc (cost=0.00..509.20 rows=22,720 width=52) (actual time=0.016..9.176 rows=22,720 loops=3)

50. 51.599 171.039 ↑ 1.2 49,295 3 / 3

Parallel Hash (cost=32,582.69..32,582.69 rows=60,169 width=96) (actual time=171.039..171.039 rows=49,295 loops=3)

  • Buckets: 32768 Batches: 8 Memory Usage: 2112kB
51. 119.440 119.440 ↑ 1.2 49,295 3 / 3

Parallel Seq Scan on batch_control bc (cost=0.00..32,582.69 rows=60,169 width=96) (actual time=0.009..119.440 rows=49,295 loops=3)

52. 1,533.772 2,490.887 ↑ 1.3 1,984,226 3 / 3

Parallel Hash (cost=71,952.05..71,952.05 rows=2,481,005 width=25) (actual time=2,490.887..2,490.887 rows=1,984,226 loops=3)

  • Buckets: 65536 Batches: 128 Memory Usage: 3360kB
53. 957.115 957.115 ↑ 1.3 1,984,226 3 / 3

Parallel Seq Scan on inf_hours_worked_agg tav (cost=0.00..71,952.05 rows=2,481,005 width=25) (actual time=0.010..957.115 rows=1,984,226 loops=3)

54. 0.010 0.033 ↑ 11.5 13 3 / 3

Hash (cost=11.50..11.50 rows=150 width=128) (actual time=0.033..0.033 rows=13 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
55. 0.023 0.023 ↑ 11.5 13 3 / 3

Seq Scan on employee_status_codes esc (cost=0.00..11.50 rows=150 width=128) (actual time=0.020..0.023 rows=13 loops=3)

56. 0.013 0.025 ↑ 3.8 34 3 / 3

Hash (cost=11.30..11.30 rows=130 width=128) (actual time=0.025..0.025 rows=34 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
57. 0.012 0.012 ↑ 3.8 34 3 / 3

Seq Scan on employee_type_codes etc (cost=0.00..11.30 rows=130 width=128) (actual time=0.006..0.012 rows=34 loops=3)

58. 4.973 11.406 ↑ 1.0 1,804 3 / 3

Hash (cost=350.04..350.04 rows=1,804 width=1,105) (actual time=11.406..11.406 rows=1,804 loops=3)

  • Buckets: 2048 Batches: 1 Memory Usage: 1744kB
59. 6.433 6.433 ↑ 1.0 1,804 3 / 3

Seq Scan on client_master cm (cost=0.00..350.04 rows=1,804 width=1,105) (actual time=0.012..6.433 rows=1,804 loops=3)

60.          

SubPlan (for Gather)

61. 0.000 945.770 ↓ 0.0 0 94,577

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

62. 945.770 945.770 ↓ 0.0 0 94,577

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

63. 0.000 0.000 ↑ 1.0 1 94,577

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

64. 0.000 851.193 ↓ 0.0 0 94,577

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

65. 851.193 851.193 ↓ 0.0 0 94,577

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

66. 0.000 0.000 ↑ 1.0 1 94,577

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

67. 0.000 756.616 ↓ 0.0 0 94,577

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.008..0.008 rows=0 loops=94,577)

68. 756.616 756.616 ↓ 0.0 0 94,577

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.008..0.008 rows=0 loops=94,577)

69. 0.000 0.000 ↑ 1.0 1 94,577

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

70. 94.577 756.616 ↓ 0.0 0 94,577

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.008..0.008 rows=0 loops=94,577)

71. 662.039 662.039 ↓ 0.0 0 94,577

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.007..0.007 rows=0 loops=94,577)

72. 0.000 0.000 ↑ 1.0 1 94,577

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

73. 94.577 945.770 ↑ 50.0 2 94,577

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

74. 851.193 851.193 ↑ 50.0 2 94,577

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

75. 0.000 0.000 ↑ 1.0 1 94,577

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

76. 94.577 851.193 ↑ 50.0 2 94,577

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.008..0.009 rows=2 loops=94,577)

77. 756.616 756.616 ↑ 50.0 2 94,577

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.008..0.008 rows=2 loops=94,577)

78. 0.000 0.000 ↑ 1.0 1 94,577

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

79. 94.577 851.193 ↑ 50.0 2 94,577

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.008..0.009 rows=2 loops=94,577)

80. 756.616 756.616 ↑ 50.0 2 94,577

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.007..0.008 rows=2 loops=94,577)

81. 0.000 0.000 ↑ 1.0 1 94,577

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

82. 0.000 756.616 ↑ 50.0 2 94,577

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.008..0.008 rows=2 loops=94,577)

83. 756.616 756.616 ↑ 50.0 2 94,577

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.007..0.008 rows=2 loops=94,577)

84. 0.000 0.000 ↑ 1.0 1 94,577

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

85. 189.154 851.193 ↑ 50.0 2 94,577

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.008..0.009 rows=2 loops=94,577)

86. 662.039 662.039 ↑ 50.0 2 94,577

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.007..0.007 rows=2 loops=94,577)

87. 0.000 0.000 ↑ 1.0 1 94,577

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

88. 0.000 0.000 ↓ 0.0 0 94,577

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

89. 0.000 0.000 ↑ 1.0 1 94,577

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

90. 0.000 0.000 ↓ 0.0 0 94,577

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

91. 0.000 0.000 ↑ 1.0 1 94,577

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

92. 945.770 7,566.160 ↑ 2.6 39 94,577

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.066..0.080 rows=39 loops=94,577)

93. 6,620.390 6,620.390 ↑ 2.6 39 94,577

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.065..0.070 rows=39 loops=94,577)

94. 0.000 0.000 ↑ 1.0 1 94,577

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

95. 945.770 7,187.852 ↑ 2.6 39 94,577

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.062..0.076 rows=39 loops=94,577)

96. 6,242.082 6,242.082 ↑ 2.6 39 94,577

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.062..0.066 rows=39 loops=94,577)

97. 0.000 0.000 ↑ 1.0 1 94,577

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

98. 945.770 7,187.852 ↑ 2.6 39 94,577

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.062..0.076 rows=39 loops=94,577)

99. 6,242.082 6,242.082 ↑ 2.6 39 94,577

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.061..0.066 rows=39 loops=94,577)

100. 0.000 0.000 ↑ 1.0 1 94,577

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

101. 378.308 2,553.579 ↑ 6.7 15 94,577

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.022..0.027 rows=15 loops=94,577)

102. 2,175.271 2,175.271 ↑ 6.7 15 94,577

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.021..0.023 rows=15 loops=94,577)

103. 0.000 0.000 ↑ 1.0 1 94,577

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

104. 378.308 2,364.425 ↑ 6.7 15 94,577

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.020..0.025 rows=15 loops=94,577)

105. 1,986.117 1,986.117 ↑ 6.7 15 94,577

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.019..0.021 rows=15 loops=94,577)

106. 0.000 0.000 ↑ 1.0 1 94,577

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

107. 283.731 2,175.271 ↑ 6.7 15 94,577

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.019..0.023 rows=15 loops=94,577)

108. 1,891.540 1,891.540 ↑ 6.7 15 94,577

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.018..0.020 rows=15 loops=94,577)

109. 0.000 0.000 ↑ 1.0 1 94,577

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

110. 283.731 2,175.271 ↑ 6.7 15 94,577

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.018..0.023 rows=15 loops=94,577)

111. 1,891.540 1,891.540 ↑ 6.7 15 94,577

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.018..0.020 rows=15 loops=94,577)

112. 0.000 0.000 ↑ 1.0 1 94,577

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

113. 283.731 2,080.694 ↑ 6.7 15 94,577

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.018..0.022 rows=15 loops=94,577)

114. 1,796.963 1,796.963 ↑ 6.7 15 94,577

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.017..0.019 rows=15 loops=94,577)

115. 0.000 0.000 ↑ 1.0 1 94,577

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

116. 283.731 2,080.694 ↑ 6.7 15 94,577

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.017..0.022 rows=15 loops=94,577)

117. 1,796.963 1,796.963 ↑ 6.7 15 94,577

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.017..0.019 rows=15 loops=94,577)

118. 0.000 0.000 ↑ 1.0 1 94,577

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

119. 283.731 2,080.694 ↑ 6.7 15 94,577

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.017..0.022 rows=15 loops=94,577)

120. 1,796.963 1,796.963 ↑ 6.7 15 94,577

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.017..0.019 rows=15 loops=94,577)

121. 0.000 0.000 ↑ 1.0 1 94,577

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

Planning time : 43.064 ms
Execution time : 58,552.961 ms