explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kqTV

Settings
# exclusive inclusive rows x rows loops node
1. 2,209.018 63,084.957 ↑ 10.8 94,577 1

Gather (cost=220,563.52..46,379,359.26 rows=1,019,496 width=2,986) (actual time=14,550.811..63,084.957 rows=94,577 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 77.503 15,951.864 ↑ 13.5 31,526 3 / 3

Hash Left Join (cost=219,563.52..1,235,076.38 rows=424,790 width=4,098) (actual time=14,825.721..15,951.864 rows=31,526 loops=3)

  • Hash Cond: ((epv.peo_id = cm.peo_id) AND (epv.client_id = cm.client_id))
3. 48.966 15,848.342 ↑ 13.5 31,526 3 / 3

Hash Left Join (cost=219,186.42..1,232,467.29 rows=424,790 width=3,018) (actual time=14,799.673..15,848.342 rows=31,526 loops=3)

  • Hash Cond: ((epv.peo_id = etc.peo_id) AND (epv.employee_type = etc.type_code))
4. 54.854 15,795.264 ↑ 13.5 31,526 3 / 3

Hash Left Join (cost=219,173.17..1,230,223.70 rows=424,790 width=2,954) (actual time=14,795.537..15,795.264 rows=31,526 loops=3)

  • Hash Cond: ((epv.peo_id = esc.peo_id) AND (epv.employee_status = esc.status_code))
5. 1,756.370 15,729.274 ↑ 13.5 31,526 3 / 3

Parallel Hash Left Join (cost=219,159.42..1,227,979.65 rows=424,790 width=2,890) (actual time=14,784.369..15,729.274 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. 553.989 9,396.663 ↑ 8.3 31,526 3 / 3

Parallel Hash Left Join (cost=86,829.78..889,834.61 rows=262,020 width=2,892) (actual time=9,111.658..9,396.663 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. 67.791 7,521.917 ↑ 8.3 31,526 3 / 3

Hash Left Join (cost=52,312.14..670,695.54 rows=262,020 width=2,815) (actual time=6,009.195..7,521.917 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. 54.073 7,400.229 ↑ 8.3 31,526 3 / 3

Hash Left Join (cost=51,405.34..667,725.30 rows=262,020 width=2,779) (actual time=5,955.138..7,400.229 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. 73.619 7,297.675 ↑ 8.3 31,526 3 / 3

Hash Left Join (cost=50,491.52..664,748.08 rows=262,020 width=2,786) (actual time=5,906.509..7,297.675 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. 72.292 7,218.610 ↑ 8.3 31,526 3 / 3

Hash Left Join (cost=50,470.98..662,664.10 rows=262,020 width=2,775) (actual time=5,901.032..7,218.610 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,569.123 7,101.785 ↑ 8.3 31,526 3 / 3

Parallel Hash Left Join (cost=49,957.84..660,087.53 rows=262,020 width=2,767) (actual time=5,856.139..7,101.785 rows=31,526 loops=3)

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

Parallel Hash Left Join (cost=27,707.96..466,494.04 rows=262,020 width=2,580) (actual time=4,193.978..5,162.824 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. 393.202 3,703.349 ↑ 8.3 31,526 3 / 3

Parallel Hash Left Join (cost=16,492.53..289,490.19 rows=262,020 width=2,511) (actual time=3,479.094..3,703.349 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. 37.983 3,137.526 ↑ 8.3 31,526 3 / 3

Hash Left Join (cost=1,879.86..110,178.12 rows=262,020 width=2,497) (actual time=161.587..3,137.526 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. 34.172 3,062.103 ↑ 3.5 31,526 3 / 3

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

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

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

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

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

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

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

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

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

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

21. 584.338 588.222 ↓ 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=13.020..588.222 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=845
22. 3.884 3.884 ↓ 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=11.651..11.651 rows=19,471 loops=1)

  • Index Cond: ((pay_date >= '2019-01-01'::date) AND (pay_date < '2019-01-07'::date))
23. 2,154.791 2,154.791 ↓ 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.172..0.332 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.007 ↓ 0.0 0 3 / 3

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
25. 0.006 0.006 ↓ 0.0 0 3 / 3

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

26. 0.083 10.042 ↓ 1.1 92 3 / 3

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 74kB
27. 9.959 9.959 ↓ 1.1 92 3 / 3

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

28. 14.032 45.180 ↑ 1.0 18,031 3 / 3

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

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,814kB
29. 31.148 31.148 ↑ 1.0 18,031 3 / 3

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

30. 1.551 16.343 ↑ 1.0 3,737 3 / 3

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

  • Buckets: 4,096 Batches: 1 Memory Usage: 288kB
31. 14.792 14.792 ↑ 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.476..14.792 rows=3,737 loops=3)

32. 1.652 22.288 ↑ 1.0 3,981 3 / 3

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

  • Buckets: 4,096 Batches: 1 Memory Usage: 328kB
33. 20.636 20.636 ↑ 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.881..20.636 rows=3,981 loops=3)

34. 6.050 37.440 ↑ 1.0 9,557 3 / 3

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

  • Buckets: 16,384 Batches: 1 Memory Usage: 905kB
35. 31.390 31.390 ↑ 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.851..31.390 rows=9,557 loops=3)

36. 58.301 172.621 ↑ 1.3 94,094 3 / 3

Parallel Hash (cost=11,632.97..11,632.97 rows=117,697 width=33) (actual time=172.621..172.621 rows=94,094 loops=3)

  • Buckets: 65,536 Batches: 8 Memory Usage: 3,008kB
37. 114.320 114.320 ↑ 1.3 94,094 3 / 3

Parallel Seq Scan on employee_pay ep (cost=0.00..11,632.97 rows=117,697 width=33) (actual time=0.325..114.320 rows=94,094 loops=3)

38. 94.215 203.534 ↑ 1.3 94,101 3 / 3

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

  • Buckets: 65,536 Batches: 16 Memory Usage: 2,336kB
39. 109.319 109.319 ↑ 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=1.575..109.319 rows=94,101 loops=3)

40. 180.125 369.838 ↑ 1.3 91,463 3 / 3

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

  • Buckets: 32,768 Batches: 32 Memory Usage: 1,472kB
41. 189.713 189.713 ↑ 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.009..189.713 rows=91,463 loops=3)

42. 9.461 44.533 ↑ 1.0 12,296 3 / 3

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

  • Buckets: 16,384 Batches: 1 Memory Usage: 895kB
43. 35.072 35.072 ↑ 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.503..35.072 rows=12,296 loops=3)

44. 0.222 5.446 ↑ 1.0 529 3 / 3

Hash (cost=11.29..11.29 rows=529 width=34) (actual time=5.445..5.446 rows=529 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 44kB
45. 5.224 5.224 ↑ 1.0 529 3 / 3

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

46. 13.693 48.481 ↓ 1.0 22,176 3 / 3

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

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,828kB
47. 34.788 34.788 ↓ 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=1.525..34.788 rows=22,176 loops=3)

48. 19.369 53.897 ↑ 1.0 22,720 3 / 3

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

  • Buckets: 32,768 Batches: 1 Memory Usage: 2,148kB
49. 34.528 34.528 ↑ 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.855..34.528 rows=22,720 loops=3)

50. 60.943 1,320.757 ↑ 1.2 49,296 3 / 3

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

  • Buckets: 32,768 Batches: 8 Memory Usage: 2,112kB
51. 1,259.814 1,259.814 ↑ 1.2 49,296 3 / 3

Parallel Seq Scan on batch_control bc (cost=0.00..32,582.69 rows=60,169 width=96) (actual time=1.254..1,259.814 rows=49,296 loops=3)

52. 2,303.589 4,576.241 ↑ 1.3 1,984,226 3 / 3

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

  • Buckets: 65,536 Batches: 128 Memory Usage: 3,360kB
53. 2,272.652 2,272.652 ↑ 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=2.946..2,272.652 rows=1,984,226 loops=3)

54. 0.011 11.136 ↑ 11.5 13 3 / 3

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
55. 11.125 11.125 ↑ 11.5 13 3 / 3

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

56. 0.014 4.112 ↑ 3.8 34 3 / 3

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
57. 4.098 4.098 ↑ 3.8 34 3 / 3

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

58. 4.115 26.019 ↑ 1.0 1,804 3 / 3

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

  • Buckets: 2,048 Batches: 1 Memory Usage: 1,744kB
59. 21.904 21.904 ↑ 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.481..21.904 rows=1,804 loops=3)

60.          

SubPlan (for Gather)

61. 94.577 1,324.078 ↓ 0.0 0 94,577

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

62. 1,229.501 1,229.501 ↓ 0.0 0 94,577

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.013..0.013 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. 0.000 662.039 ↓ 0.0 0 94,577

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.007..0.007 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 851.193 ↑ 50.0 2 94,577

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

74. 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)

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.007..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. 94.577 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. 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)

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. 1,040.347 7,566.160 ↑ 2.6 39 94,577

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

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

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.064..0.069 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. 851.193 7,093.275 ↑ 2.6 39 94,577

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.062..0.075 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.061..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 6,998.698 ↑ 2.6 39 94,577

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

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

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.060..0.064 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,648.156 ↑ 6.7 15 94,577

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

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

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.022..0.024 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.018..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,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)

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

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.018..0.019 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.017..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. 378.308 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,702.386 1,702.386 ↑ 6.7 15 94,577

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.017..0.018 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 : 1,011.649 ms
Execution time : 63,102.074 ms