explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qbCV

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 1,872,642.971 ↑ 1.0 1 1

Sort (cost=13,651,156,196.25..13,651,156,196.25 rows=1 width=8) (actual time=1,872,642.971..1,872,642.971 rows=1 loops=1)

  • Sort Key: (count(DISTINCT i.issueid))
  • Sort Method: quicksort Memory: 25kB
2.          

CTE auth

3. 0.081 15.515 ↑ 7,028.0 306 1

Merge Left Join (cost=77,280.91..109,825.11 rows=2,150,581 width=168) (actual time=15.422..15.515 rows=306 loops=1)

  • Merge Cond: (ucea.networksite_id = snetworkchild.parent_networksite_id)
4. 0.169 15.434 ↑ 187.5 306 1

Sort (cost=66,517.21..66,660.65 rows=57,376 width=160) (actual time=15.419..15.434 rows=306 loops=1)

  • Sort Key: ucea.networksite_id
  • Sort Method: quicksort Memory: 68kB
5. 0.877 15.265 ↑ 187.5 306 1

Hash Right Join (cost=39,257.07..61,982.16 rows=57,376 width=160) (actual time=15.189..15.265 rows=306 loops=1)

  • Hash Cond: ((CASE WHEN (pgparents.parentuid IS NULL) THEN pgparents.projectgroupuid ELSE pgparents.parentuid END) = ucea.project_group_uid)
6. 0.891 4.481 ↑ 114.1 3,448 1

Merge Join (cost=11,909.57..17,829.24 rows=393,495 width=32) (actual time=3.208..4.481 rows=3,448 loops=1)

  • Merge Cond: (p_1.projectgroupuid = pgparents.projectgroupuid)
7.          

CTE pgparents

8. 0.131 0.693 ↑ 81.7 957 1

Recursive Union (cost=0.00..3,651.66 rows=78,174 width=40) (actual time=0.007..0.693 rows=957 loops=1)

9. 0.133 0.133 ↓ 1.0 808 1

Seq Scan on projectgroup pg (cost=0.00..21.74 rows=774 width=40) (actual time=0.006..0.133 rows=808 loops=1)

10. 0.099 0.429 ↑ 154.8 50 3

Hash Join (cost=31.42..206.64 rows=7,740 width=40) (actual time=0.102..0.143 rows=50 loops=3)

  • Hash Cond: (pgparents_1.parentuid = pg2.projectgroupuid)
11. 0.051 0.051 ↑ 24.3 319 3

WorkTable Scan on pgparents pgparents_1 (cost=0.00..154.80 rows=7,740 width=32) (actual time=0.000..0.017 rows=319 loops=3)

12. 0.148 0.279 ↓ 1.0 808 1

Hash (cost=21.74..21.74 rows=774 width=40) (actual time=0.278..0.279 rows=808 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 54kB
13. 0.131 0.131 ↓ 1.0 808 1

Seq Scan on projectgroup pg2 (cost=0.00..21.74 rows=774 width=40) (actual time=0.004..0.131 rows=808 loops=1)

14. 1.328 2.217 ↑ 1.0 3,388 1

Sort (cost=341.08..349.70 rows=3,448 width=24) (actual time=2.019..2.217 rows=3,388 loops=1)

  • Sort Key: p_1.projectgroupuid
  • Sort Method: quicksort Memory: 361kB
15. 0.889 0.889 ↑ 1.0 3,388 1

Seq Scan on project p_1 (cost=0.00..138.48 rows=3,448 width=24) (actual time=0.006..0.889 rows=3,388 loops=1)

16. 0.447 1.373 ↑ 20.9 3,737 1

Sort (cost=7,916.84..8,112.27 rows=78,174 width=32) (actual time=1.186..1.373 rows=3,737 loops=1)

  • Sort Key: pgparents.projectgroupuid
  • Sort Method: quicksort Memory: 74kB
17. 0.926 0.926 ↑ 81.7 957 1

CTE Scan on pgparents (cost=0.00..1,563.48 rows=78,174 width=32) (actual time=0.009..0.926 rows=957 loops=1)

18. 0.123 9.907 ↓ 1.8 306 1

Hash (cost=27,345.42..27,345.42 rows=166 width=168) (actual time=9.907..9.907 rows=306 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 44kB
19. 1.695 9.784 ↓ 1.8 306 1

Hash Left Join (cost=26,785.13..27,345.42 rows=166 width=168) (actual time=9.085..9.784 rows=306 loops=1)

  • Hash Cond: (ucea.project_id = pppg.project_id)
20. 0.098 2.128 ↓ 1.8 306 1

Hash Left Join (cost=102.26..661.28 rows=166 width=144) (actual time=1.489..2.128 rows=306 loops=1)

  • Hash Cond: (ucea.client_id = ag.clientid)
21. 0.108 1.571 ↓ 1.8 306 1

Hash Left Join (cost=65.32..623.47 rows=166 width=136) (actual time=1.008..1.571 rows=306 loops=1)

  • Hash Cond: (ucea.client_id = ns_1.clientid)
22. 0.042 0.821 ↓ 1.8 306 1

Nested Loop Left Join (cost=20.76..577.63 rows=166 width=128) (actual time=0.342..0.821 rows=306 loops=1)

23. 0.031 0.383 ↑ 3.5 36 1

Hash Left Join (cost=20.20..398.25 rows=127 width=120) (actual time=0.302..0.383 rows=36 loops=1)

  • Hash Cond: (ucea.application_group_id = agroupchild.applicationgroupid)
24. 0.015 0.205 ↑ 3.5 36 1

Nested Loop (cost=5.00..376.50 rows=127 width=112) (actual time=0.133..0.205 rows=36 loops=1)

25. 0.007 0.136 ↑ 1.4 18 1

Nested Loop (cost=4.72..128.52 rows=25 width=56) (actual time=0.109..0.136 rows=18 loops=1)

26. 0.021 0.021 ↑ 1.0 1 1

Seq Scan on tablemetadata t (cost=0.00..2.98 rows=1 width=27) (actual time=0.014..0.021 rows=1 loops=1)

  • Filter: ((modelname)::text = 'finding'::text)
  • Rows Removed by Filter: 78
27. 0.011 0.108 ↓ 1.1 18 1

Nested Loop (cost=4.72..125.38 rows=16 width=37) (actual time=0.092..0.108 rows=18 loops=1)

28. 0.057 0.057 ↑ 8.0 1 1

Index Only Scan using users_roles_user_id_usergroup_role_id on users_roles ur (cost=0.28..27.51 rows=8 width=24) (actual time=0.056..0.057 rows=1 loops=1)

  • Index Cond: (user_id = 669)
  • Heap Fetches: 1
29. 0.016 0.040 ↓ 9.0 18 1

Bitmap Heap Scan on role_permissions_association rpa (cost=4.44..12.21 rows=2 width=29) (actual time=0.030..0.040 rows=18 loops=1)

  • Recheck Cond: ((entity_id = t.tablesequenceid) AND (role_id = ur.role_id) AND (module_id = 1))
  • Heap Blocks: exact=3
30. 0.024 0.024 ↓ 9.0 18 1

Bitmap Index Scan on role_permissions_association_entity_id_role_id_workbench_index (cost=0.00..4.43 rows=2 width=0) (actual time=0.024..0.024 rows=18 loops=1)

  • Index Cond: ((entity_id = t.tablesequenceid) AND (role_id = ur.role_id))
31. 0.054 0.054 ↑ 2.0 2 18

Index Only Scan using usergroup_id_client_entities_association_incl on usergroup_client_entities_association ucea (cost=0.28..9.88 rows=4 width=72) (actual time=0.003..0.003 rows=2 loops=18)

  • Index Cond: (usergroup_id = ur.user_group_id)
  • Heap Fetches: 0
32. 0.060 0.147 ↓ 1.0 334 1

Hash (cost=11.20..11.20 rows=320 width=16) (actual time=0.146..0.147 rows=334 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 24kB
33. 0.087 0.087 ↓ 1.0 334 1

Seq Scan on application agroupchild (cost=0.00..11.20 rows=320 width=16) (actual time=0.010..0.087 rows=334 loops=1)

34. 0.108 0.396 ↓ 2.0 8 36

Nested Loop (cost=0.56..1.37 rows=4 width=16) (actual time=0.004..0.011 rows=8 loops=36)

35. 0.072 0.072 ↓ 2.0 2 36

Index Scan using ix_projectgroup_clientid on projectgroup pg_2 (cost=0.28..0.30 rows=1 width=24) (actual time=0.002..0.002 rows=2 loops=36)

  • Index Cond: (clientid = ucea.client_id)
36. 0.216 0.216 ↑ 1.2 4 72

Index Scan using project_projectgroupuid_index on project p (cost=0.28..1.02 rows=5 width=24) (actual time=0.002..0.003 rows=4 loops=72)

  • Index Cond: (projectgroupuid = pg_2.projectgroupuid)
37. 0.104 0.642 ↓ 1.0 627 1

Hash (cost=36.86..36.86 rows=616 width=16) (actual time=0.642..0.642 rows=627 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 38kB
38. 0.172 0.538 ↓ 1.0 628 1

Hash Join (cost=21.07..36.86 rows=616 width=16) (actual time=0.325..0.538 rows=628 loops=1)

  • Hash Cond: (s.networksiteid = ns_1.networksiteid)
39. 0.070 0.070 ↓ 1.0 628 1

Seq Scan on site s (cost=0.00..14.16 rows=616 width=16) (actual time=0.006..0.070 rows=628 loops=1)

40. 0.172 0.296 ↓ 1.0 596 1

Hash (cost=13.81..13.81 rows=581 width=16) (actual time=0.296..0.296 rows=596 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 36kB
41. 0.124 0.124 ↓ 1.0 596 1

Seq Scan on networksite ns_1 (cost=0.00..13.81 rows=581 width=16) (actual time=0.009..0.124 rows=596 loops=1)

42. 0.056 0.459 ↓ 1.0 334 1

Hash (cost=32.94..32.94 rows=320 width=16) (actual time=0.459..0.459 rows=334 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 24kB
43. 0.109 0.403 ↓ 1.0 334 1

Hash Join (cost=20.89..32.94 rows=320 width=16) (actual time=0.281..0.403 rows=334 loops=1)

  • Hash Cond: (a_1.applicationgroupid = ag.applicationgroupid)
44. 0.036 0.036 ↓ 1.0 334 1

Seq Scan on application a_1 (cost=0.00..11.20 rows=320 width=16) (actual time=0.004..0.036 rows=334 loops=1)

45. 0.114 0.258 ↓ 1.0 589 1

Hash (cost=13.73..13.73 rows=573 width=16) (actual time=0.258..0.258 rows=589 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 36kB
46. 0.144 0.144 ↓ 1.0 589 1

Seq Scan on applicationgroup ag (cost=0.00..13.73 rows=573 width=16) (actual time=0.011..0.144 rows=589 loops=1)

47. 0.865 5.961 ↑ 114.1 3,448 1

Hash (cost=21,764.19..21,764.19 rows=393,495 width=32) (actual time=5.961..5.961 rows=3,448 loops=1)

  • Buckets: 524,288 Batches: 1 Memory Usage: 4,312kB
48. 0.298 5.096 ↑ 114.1 3,448 1

Subquery Scan on pppg (cost=11,909.57..21,764.19 rows=393,495 width=32) (actual time=3.423..5.096 rows=3,448 loops=1)

49. 0.923 4.798 ↑ 114.1 3,448 1

Merge Join (cost=11,909.57..17,829.24 rows=393,495 width=32) (actual time=3.422..4.798 rows=3,448 loops=1)

  • Merge Cond: (p_2.projectgroupuid = pgparents_2.projectgroupuid)
50.          

CTE pgparents

51. 0.129 0.740 ↑ 81.7 957 1

Recursive Union (cost=0.00..3,651.66 rows=78,174 width=40) (actual time=0.009..0.740 rows=957 loops=1)

52. 0.182 0.182 ↓ 1.0 808 1

Seq Scan on projectgroup pg_1 (cost=0.00..21.74 rows=774 width=40) (actual time=0.008..0.182 rows=808 loops=1)

53. 0.107 0.429 ↑ 154.8 50 3

Hash Join (cost=31.42..206.64 rows=7,740 width=40) (actual time=0.100..0.143 rows=50 loops=3)

  • Hash Cond: (pgparents_1_1.parentuid = pg2_1.projectgroupuid)
54. 0.051 0.051 ↑ 24.3 319 3

WorkTable Scan on pgparents pgparents_1_1 (cost=0.00..154.80 rows=7,740 width=32) (actual time=0.000..0.017 rows=319 loops=3)

55. 0.144 0.271 ↓ 1.0 808 1

Hash (cost=21.74..21.74 rows=774 width=40) (actual time=0.271..0.271 rows=808 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 54kB
56. 0.127 0.127 ↓ 1.0 808 1

Seq Scan on projectgroup pg2_1 (cost=0.00..21.74 rows=774 width=40) (actual time=0.004..0.127 rows=808 loops=1)

57. 1.301 2.388 ↑ 1.0 3,388 1

Sort (cost=341.08..349.70 rows=3,448 width=24) (actual time=2.131..2.388 rows=3,388 loops=1)

  • Sort Key: p_2.projectgroupuid
  • Sort Method: quicksort Memory: 361kB
58. 1.087 1.087 ↑ 1.0 3,388 1

Seq Scan on project p_2 (cost=0.00..138.48 rows=3,448 width=24) (actual time=0.011..1.087 rows=3,388 loops=1)

59. 0.492 1.487 ↑ 20.9 3,737 1

Sort (cost=7,916.84..8,112.27 rows=78,174 width=40) (actual time=1.286..1.487 rows=3,737 loops=1)

  • Sort Key: pgparents_2.projectgroupuid
  • Sort Method: quicksort Memory: 99kB
60. 0.995 0.995 ↑ 81.7 957 1

CTE Scan on pgparents pgparents_2 (cost=0.00..1,563.48 rows=78,174 width=40) (actual time=0.011..0.995 rows=957 loops=1)

61. 0.000 0.000 ↓ 0.0 0

Sort (cost=10,763.70..10,920.86 rows=62,865 width=16) (never executed)

  • Sort Key: snetworkchild.parent_networksite_id
62. 0.000 0.000 ↓ 0.0 0

Subquery Scan on snetworkchild (cost=2,735.64..5,753.37 rows=62,865 width=16) (never executed)

63. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=2,735.64..5,124.72 rows=62,865 width=24) (never executed)

  • Hash Cond: (siteparents.networksiteid = s_1.networksiteid)
64.          

CTE siteparents

65. 0.000 0.000 ↓ 0.0 0

Recursive Union (cost=0.00..2,713.78 rows=58,681 width=24) (never executed)

66. 0.000 0.000 ↓ 0.0 0

Seq Scan on networksite ns (cost=0.00..13.81 rows=581 width=24) (never executed)

67. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=21.07..152.63 rows=5,810 width=24) (never executed)

  • Hash Cond: (siteparents_1.parentnetworksiteid = ns2.networksiteid)
68. 0.000 0.000 ↓ 0.0 0

WorkTable Scan on siteparents siteparents_1 (cost=0.00..116.20 rows=5,810 width=16) (never executed)

69. 0.000 0.000 ↓ 0.0 0

Hash (cost=13.81..13.81 rows=581 width=24) (never executed)

70. 0.000 0.000 ↓ 0.0 0

Seq Scan on networksite ns2 (cost=0.00..13.81 rows=581 width=24) (never executed)

71. 0.000 0.000 ↓ 0.0 0

CTE Scan on siteparents (cost=0.00..1,173.62 rows=58,681 width=16) (never executed)

72. 0.000 0.000 ↓ 0.0 0

Hash (cost=14.16..14.16 rows=616 width=16) (never executed)

73. 0.000 0.000 ↓ 0.0 0

Seq Scan on site s_1 (cost=0.00..14.16 rows=616 width=16) (never executed)

74. 0.817 1,872,642.967 ↑ 1.0 1 1

Aggregate (cost=13,651,046,371.12..13,651,046,371.13 rows=1 width=8) (actual time=1,872,642.966..1,872,642.967 rows=1 loops=1)

75. 55,372.222 1,872,642.150 ↑ 87.0 1,754 1

Nested Loop (cost=10,666.91..13,651,045,989.70 rows=152,568 width=8) (actual time=1,196,328.954..1,872,642.150 rows=1,754 loops=1)

  • Join Filter: (((pf.project_id IS NOT NULL) AND (SubPlan 6)) OR ((z.siteid IS NOT NULL) AND (SubPlan 7)) OR ((aa.application_id IS NOT NULL) AND (SubPlan 8)) OR ((z.clientid IS NOT NULL) AND (SubPlan 9)))
  • Rows Removed by Join Filter: 731,533
76. 26,237.981 1,655,714.770 ↓ 5.1 719,842 1

Gather Merge (cost=10,666.91..111,347,669.45 rows=139,907 width=40) (actual time=620.636..1,655,714.770 rows=719,842 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
77. 791.795 1,629,476.789 ↓ 4.1 239,947 3 / 3

Nested Loop Left Join (cost=9,666.89..111,330,520.69 rows=58,295 width=40) (actual time=582.097..1,629,476.789 rows=239,947 loops=3)

78. 606,983.103 1,627,245.340 ↓ 4.1 239,942 3 / 3

Nested Loop (cost=9,666.61..111,312,117.28 rows=58,295 width=48) (actual time=582.049..1,627,245.340 rows=239,942 loops=3)

  • Join Filter: (i.issueid = f.issueid)
  • Rows Removed by Join Filter: 5,910,019,151
79. 1,147.356 1,147.356 ↑ 1.3 253,008 3 / 3

Parallel Index Scan using finding_id_final_remediated_state on finding f (cost=0.42..212,430.60 rows=317,306 width=24) (actual time=44.573..1,147.356 rows=253,008 loops=3)

80. 956,592.617 1,019,114.881 ↓ 1.0 23,360 759,023 / 3

Hash Right Join (cost=9,666.18..9,734.77 rows=22,521 width=40) (actual time=0.024..4.028 rows=23,360 loops=759,023)

  • Hash Cond: (cpmv.masterfindingid = mf.masterfindingid)
81. 61,986.878 61,986.878 ↑ 1.0 2,131 759,023 / 3

Seq Scan on cve_prioritization_materialized_view cpmv (cost=0.00..36.31 rows=2,131 width=8) (actual time=0.006..0.245 rows=2,131 loops=759,023)

82. 5.453 535.386 ↓ 1.0 23,164 3 / 3

Hash (cost=9,384.67..9,384.67 rows=22,521 width=40) (actual time=535.386..535.386 rows=23,164 loops=3)

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,736kB
83. 5.292 529.933 ↓ 1.0 23,164 3 / 3

Hash Join (cost=6,159.77..9,384.67 rows=22,521 width=40) (actual time=489.673..529.933 rows=23,164 loops=3)

  • Hash Cond: (mf.master_finding_parent_id = mfp.id)
84. 3.942 519.435 ↓ 1.0 23,177 3 / 3

Hash Left Join (cost=5,419.92..8,585.69 rows=22,521 width=48) (actual time=484.344..519.435 rows=23,177 loops=3)

  • Hash Cond: (a.assetid = aa.asset_id)
85. 5.605 515.369 ↓ 1.0 22,780 3 / 3

Hash Join (cost=5,410.55..8,237.10 rows=22,521 width=48) (actual time=484.194..515.369 rows=22,780 loops=3)

  • Hash Cond: (i.masterfindingid = mf.masterfindingid)
86. 3.255 465.396 ↓ 1.0 22,780 3 / 3

Hash Left Join (cost=2,415.02..5,182.44 rows=22,521 width=40) (actual time=439.650..465.396 rows=22,780 loops=3)

  • Hash Cond: (a.assetid = apl.asset_id)
87. 5.091 462.107 ↑ 1.0 22,505 3 / 3

Hash Join (cost=2,413.41..5,096.25 rows=22,521 width=40) (actual time=439.601..462.107 rows=22,505 loops=3)

  • Hash Cond: (a.zoneid = z.zoneid)
88. 6.238 456.714 ↑ 1.0 22,505 3 / 3

Hash Join (cost=2,388.07..5,011.42 rows=22,523 width=32) (actual time=439.278..456.714 rows=22,505 loops=3)

  • Hash Cond: (i.assetid = a.assetid)
89. 11.697 416.717 ↑ 1.0 22,506 3 / 3

Bitmap Heap Scan on issue i (cost=502.97..3,067.20 rows=22,523 width=24) (actual time=405.179..416.717 rows=22,506 loops=3)

  • Filter: (is_published IS TRUE)
  • Heap Blocks: exact=1,023
90. 405.020 405.020 ↓ 1.6 36,279 3 / 3

Bitmap Index Scan on issue_is_published_index (cost=0.00..497.34 rows=22,523 width=0) (actual time=405.020..405.020 rows=36,279 loops=3)

  • Index Cond: (is_published = true)
91. 11.216 33.759 ↑ 1.0 45,315 3 / 3

Hash (cost=1,317.82..1,317.82 rows=45,382 width=16) (actual time=33.758..33.759 rows=45,315 loops=3)

  • Buckets: 65,536 Batches: 1 Memory Usage: 2,637kB
92. 22.543 22.543 ↑ 1.0 45,315 3 / 3

Seq Scan on asset a (cost=0.00..1,317.82 rows=45,382 width=16) (actual time=0.024..22.543 rows=45,315 loops=3)

93. 0.126 0.302 ↓ 1.0 688 3 / 3

Hash (cost=16.82..16.82 rows=682 width=24) (actual time=0.302..0.302 rows=688 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 46kB
94. 0.176 0.176 ↓ 1.0 688 3 / 3

Seq Scan on zone z (cost=0.00..16.82 rows=682 width=24) (actual time=0.018..0.176 rows=688 loops=3)

95. 0.010 0.034 ↑ 1.0 27 3 / 3

Hash (cost=1.27..1.27 rows=27 width=8) (actual time=0.033..0.034 rows=27 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
96. 0.024 0.024 ↑ 1.0 27 3 / 3

Seq Scan on asset_physical_location_mav apl (cost=0.00..1.27 rows=27 width=8) (actual time=0.022..0.024 rows=27 loops=3)

97. 8.718 44.368 ↓ 1.0 19,785 3 / 3

Hash (cost=2,749.68..2,749.68 rows=19,668 width=24) (actual time=44.368..44.368 rows=19,785 loops=3)

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,233kB
98. 35.650 35.650 ↓ 1.0 19,785 3 / 3

Seq Scan on masterfinding mf (cost=0.00..2,749.68 rows=19,668 width=24) (actual time=0.013..35.650 rows=19,785 loops=3)

99. 0.052 0.124 ↓ 1.1 299 3 / 3

Hash (cost=5.83..5.83 rows=283 width=16) (actual time=0.124..0.124 rows=299 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 23kB
100. 0.072 0.072 ↓ 1.1 299 3 / 3

Seq Scan on application_asset aa (cost=0.00..5.83 rows=283 width=16) (actual time=0.023..0.072 rows=299 loops=3)

101. 2.757 5.206 ↓ 1.0 18,551 3 / 3

Hash (cost=508.25..508.25 rows=18,528 width=8) (actual time=5.206..5.206 rows=18,551 loops=3)

  • Buckets: 32,768 Batches: 1 Memory Usage: 981kB
102. 2.449 2.449 ↓ 1.0 18,551 3 / 3

Index Only Scan using master_finding_parent_id_key on master_finding_parent mfp (cost=0.29..508.25 rows=18,528 width=8) (actual time=0.044..2.449 rows=18,551 loops=3)

  • Heap Fetches: 1,833
103. 1,439.654 1,439.654 ↓ 0.0 0 719,827 / 3

Index Only Scan using masterfindingcategory_masterfindingid_incl on masterfindingcategory mfg (cost=0.28..0.31 rows=1 width=16) (actual time=0.006..0.006 rows=0 loops=719,827)

  • Index Cond: (masterfindingid = mf.masterfindingid)
  • Heap Fetches: 0
104. 4,319.052 4,319.052 ↑ 1.0 1 719,842

Index Scan using project_finding_finding_id_hash on project_finding pf (cost=0.00..0.25 rows=1 width=16) (actual time=0.005..0.006 rows=1 loops=719,842)

  • Index Cond: (finding_id = f.findingid)
  • Rows Removed by Index Recheck: 0
105.          

SubPlan (for Nested Loop)

106. 49,863.516 49,863.516 ↑ 7,051.1 305 733,287

CTE Scan on auth (cost=0.00..43,011.62 rows=2,150,581 width=8) (actual time=0.001..0.068 rows=305 loops=733,287)

107. 57,791.107 57,791.107 ↑ 7,028.0 306 731,533

CTE Scan on auth auth_1 (cost=0.00..43,011.62 rows=2,150,581 width=8) (actual time=0.000..0.079 rows=306 loops=731,533)

108. 3,497.109 3,497.109 ↑ 7,028.0 306 45,417

CTE Scan on auth auth_2 (cost=0.00..43,011.62 rows=2,150,581 width=8) (actual time=0.000..0.077 rows=306 loops=45,417)

109. 46,084.374 46,084.374 ↑ 7,028.0 306 731,498

CTE Scan on auth auth_3 (cost=0.00..43,011.62 rows=2,150,581 width=8) (actual time=0.000..0.063 rows=306 loops=731,498)

Planning time : 17.020 ms
Execution time : 1,872,671.190 ms