explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NsMh

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 25,253.949 ↑ 1.0 20 1

Limit (cost=14,956,468.82..14,959,463.63 rows=20 width=380) (actual time=25,253.099..25,253.949 rows=20 loops=1)

2. 13,380.004 25,253.946 ↑ 74,583.8 20 1

Result (cost=14,956,468.82..238,320,692.54 rows=1,491,676 width=380) (actual time=25,253.098..25,253.946 rows=20 loops=1)

3. 451.975 3,120.574 ↑ 74,583.8 20 1

Sort (cost=14,956,468.82..14,960,198.01 rows=1,491,676 width=238) (actual time=3,120.569..3,120.574 rows=20 loops=1)

  • Sort Key: (("*SELECT* 1".name)::text) COLLATE "en_US", "*SELECT* 1".projectid
  • Sort Method: top-N heapsort Memory: 43kB
4. 131.351 2,668.599 ↑ 1.5 994,471 1

Result (cost=0.57..14,916,775.86 rows=1,491,676 width=238) (actual time=1,237.638..2,668.599 rows=994,471 loops=1)

5. 75.695 2,537.248 ↑ 1.5 994,471 1

Append (cost=0.57..14,901,859.10 rows=1,491,676 width=280) (actual time=1,237.636..2,537.248 rows=994,471 loops=1)

6. 712.134 2,461.549 ↑ 1.5 994,471 1

Subquery Scan on *SELECT* 1 (cost=0.57..14,901,553.30 rows=1,491,646 width=280) (actual time=1,237.636..2,461.549 rows=994,471 loops=1)

  • Filter: (alternatives: SubPlan 47 or hashed SubPlan 48)
7. 305.640 830.133 ↑ 3.0 994,471 1

Merge Anti Join (cost=0.57..268,501.13 rows=2,983,293 width=660) (actual time=0.029..830.133 rows=994,471 loops=1)

  • Merge Cond: (dm_projectlist_facts.projectid = dm_projectlist_realtime_facts.projectid)
8. 524.488 524.488 ↑ 3.0 994,471 1

Index Scan using dm_projectlist_facts_pkey on dm_projectlist_facts (cost=0.43..261,028.16 rows=2,983,413 width=280) (actual time=0.022..524.488 rows=994,471 loops=1)

  • Filter: ((statustype <> 5) OR (statustype IS NULL))
9. 0.005 0.005 ↓ 0.0 0 1

Index Only Scan using dm_projectlist_realtime_facts_pkey on dm_projectlist_realtime_facts (cost=0.14..12.94 rows=120 width=4) (actual time=0.005..0.005 rows=0 loops=1)

  • Heap Fetches: 0
10.          

SubPlan (for Subquery Scan)

11. 0.000 0.000 ↓ 0.0 0

Nested Loop Semi Join (cost=0.85..4.89 rows=1 width=0) (never executed)

12. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on project project38 (cost=0.42..2.44 rows=1 width=4) (never executed)

  • Index Cond: (id = "*SELECT* 1".projectid)
  • Heap Fetches: 0
13. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on project project39 (cost=0.42..2.44 rows=1 width=4) (never executed)

  • Index Cond: (id = "*SELECT* 1".projectid)
  • Heap Fetches: 0
14. 266.492 919.282 ↑ 1.0 994,471 1

Merge Join (cost=0.85..191,948.05 rows=994,471 width=4) (actual time=0.097..919.282 rows=994,471 loops=1)

  • Merge Cond: (project38_1.id = project39_1.id)
15. 385.307 385.307 ↑ 1.0 994,471 1

Index Only Scan using project_pkey on project project38_1 (cost=0.42..88,515.49 rows=994,471 width=4) (actual time=0.060..385.307 rows=994,471 loops=1)

  • Heap Fetches: 994,471
16. 267.483 267.483 ↑ 1.0 994,471 1

Index Only Scan using project_pkey on project project39_1 (cost=0.42..88,515.49 rows=994,471 width=4) (actual time=0.031..267.483 rows=994,471 loops=1)

  • Heap Fetches: 994,471
17. 0.001 0.004 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2 (cost=0.00..305.80 rows=30 width=236) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (alternatives: SubPlan 47 or hashed SubPlan 48)
18. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on dm_projectlist_realtime_facts dm_projectlist_realtime_facts_1 (cost=0.00..11.50 rows=60 width=616) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((NOT deleted) AND ((statustype <> 5) OR (statustype IS NULL)))
19.          

SubPlan (for Result)

20. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.58..19.65 rows=1 width=0) (never executed)

  • Join Filter: (project1.id = projectclient3.projectid)
  • Filter: ((alternatives: SubPlan 1 or hashed SubPlan 2) OR (project1.projectleaderapproverid = 2) OR (projectsharingassignment2.userid = 2) OR (clients4.clientmanageruserid = 2) OR (clientsharingassignment5.userid = 2))
21. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.58..11.93 rows=1 width=12) (never executed)

  • Join Filter: (projectsharingassignment2.projectid = project1.id)
22. 0.000 0.000 ↓ 0.0 0

Index Scan using project_pkey on project project1 (cost=0.42..2.44 rows=1 width=8) (never executed)

  • Index Cond: ("*SELECT* 1".projectid = id)
23. 0.000 0.000 ↓ 0.0 0

Index Only Scan using projectsharingassignment_pkey on projectsharingassignment projectsharingassignment2 (cost=0.15..9.35 rows=11 width=8) (never executed)

  • Index Cond: (projectid = "*SELECT* 1".projectid)
  • Heap Fetches: 0
24. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.00..5.25 rows=1 width=12) (never executed)

25. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.84..4.88 rows=1 width=12) (never executed)

26. 0.000 0.000 ↓ 0.0 0

Index Only Scan using uix4pc_projectclienteffectiveend on projectclient projectclient3 (cost=0.42..2.44 rows=1 width=8) (never executed)

  • Index Cond: (projectid = "*SELECT* 1".projectid)
  • Heap Fetches: 0
27. 0.000 0.000 ↓ 0.0 0

Index Scan using clients_pkey on clients clients4 (cost=0.42..2.44 rows=1 width=8) (never executed)

  • Index Cond: (projectclient3.clientid = id)
28. 0.000 0.000 ↓ 0.0 0

Index Scan using ixcsaclientid on clientsharingassignment clientsharingassignment5 (cost=0.15..0.29 rows=8 width=8) (never executed)

  • Index Cond: (clientid = clients4.id)
29.          

SubPlan (for Nested Loop Left Join)

30. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on project project6 (cost=0.42..2.44 rows=1 width=0) (never executed)

  • Index Cond: (id = project1.id)
  • Heap Fetches: 0
31. 0.000 0.000 ↓ 0.0 0

Seq Scan on project project6_1 (cost=0.00..80,812.71 rows=994,471 width=4) (never executed)

32. 938.784 2,889.481 ↓ 1.3 994,471 1

Hash Right Join (cost=182,372.44..192,852.76 rows=783,724 width=4) (actual time=2,251.909..2,889.481 rows=994,471 loops=1)

  • Hash Cond: (projectsharingassignment2_1.projectid = project1_1.id)
  • Filter: ((alternatives: SubPlan 4 or hashed SubPlan 5) OR (project1_1.projectleaderapproverid = 2) OR (projectsharingassignment2_1.userid = 2) OR (clients4_1.clientmanageruserid = 2) OR (clientsharingassignment5_1.userid = 2))
33. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on projectsharingassignment projectsharingassignment2_1 (cost=0.00..32.60 rows=2,260 width=8) (actual time=0.004..0.004 rows=0 loops=1)

34. 208.712 1,757.170 ↑ 1.0 994,471 1

Hash (cost=165,085.55..165,085.55 rows=994,471 width=16) (actual time=1,757.170..1,757.170 rows=994,471 loops=1)

  • Buckets: 1,048,576 Batches: 2 Memory Usage: 29,567kB
35. 249.390 1,548.458 ↑ 1.0 994,471 1

Hash Left Join (cost=20,942.38..165,085.55 rows=994,471 width=16) (actual time=200.138..1,548.458 rows=994,471 loops=1)

  • Hash Cond: (projectclient3_1.clientid = clients4_1.id)
36. 445.672 1,100.587 ↑ 1.0 994,471 1

Merge Left Join (cost=0.85..130,470.05 rows=994,471 width=12) (actual time=0.084..1,100.587 rows=994,471 loops=1)

  • Merge Cond: (project1_1.id = projectclient3_1.projectid)
37. 354.238 354.238 ↑ 1.0 994,471 1

Index Scan using project_pkey on project project1_1 (cost=0.42..88,515.49 rows=994,471 width=8) (actual time=0.045..354.238 rows=994,471 loops=1)

38. 300.677 300.677 ↑ 1.0 994,471 1

Index Only Scan using uix4pc_projectclienteffectiveend on projectclient projectclient3_1 (cost=0.42..27,037.49 rows=994,471 width=8) (actual time=0.034..300.677 rows=994,471 loops=1)

  • Heap Fetches: 994,471
39. 49.698 198.481 ↑ 1.0 231,426 1

Hash (cost=18,048.70..18,048.70 rows=231,426 width=12) (actual time=198.481..198.481 rows=231,426 loops=1)

  • Buckets: 262,144 Batches: 1 Memory Usage: 11,089kB
40. 53.469 148.783 ↑ 1.0 231,426 1

Merge Left Join (cost=0.57..18,048.70 rows=231,426 width=12) (actual time=0.070..148.783 rows=231,426 loops=1)

  • Merge Cond: (clients4_1.id = clientsharingassignment5_1.clientid)
41. 95.305 95.305 ↑ 1.0 231,426 1

Index Scan using clients_pkey on clients clients4_1 (cost=0.42..17,415.81 rows=231,426 width=8) (actual time=0.058..95.305 rows=231,426 loops=1)

42. 0.009 0.009 ↓ 0.0 0 1

Index Scan using ixcsaclientid on clientsharingassignment clientsharingassignment5_1 (cost=0.15..34.70 rows=1,570 width=8) (actual time=0.009..0.009 rows=0 loops=1)

43.          

SubPlan (for Hash Right Join)

44. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on project project6_2 (cost=0.42..2.44 rows=1 width=0) (never executed)

  • Index Cond: (id = project1_1.id)
  • Heap Fetches: 0
45. 193.523 193.523 ↑ 1.0 994,471 1

Seq Scan on project project6_3 (cost=0.00..80,812.71 rows=994,471 width=4) (actual time=0.013..193.523 rows=994,471 loops=1)

46. 0.020 0.300 ↑ 1.0 1 20

Limit (cost=4.90..4.90 rows=1 width=521) (actual time=0.015..0.015 rows=1 loops=20)

47. 0.060 0.280 ↑ 1.0 1 20

Sort (cost=4.90..4.90 rows=1 width=521) (actual time=0.014..0.014 rows=1 loops=20)

  • Sort Key: projectclient8.costallocationpercentage DESC, ((clients7.name)::character varying(255)) COLLATE "en_US
  • Sort Method: quicksort Memory: 25kB
48. 0.020 0.220 ↑ 1.0 1 20

Nested Loop (cost=0.84..4.89 rows=1 width=521) (actual time=0.011..0.011 rows=1 loops=20)

49. 0.120 0.120 ↑ 1.0 1 20

Index Scan using uix4pc_projectclienteffectiveend on projectclient projectclient8 (cost=0.42..2.45 rows=1 width=9) (actual time=0.005..0.006 rows=1 loops=20)

  • Index Cond: ((projectid = "*SELECT* 1".projectid) AND (effectivedate <= '2020-09-03'::date) AND (enddate >= '2020-09-03'::date))
50. 0.080 0.080 ↑ 1.0 1 20

Index Scan using clients_pkey on clients clients7 (cost=0.42..2.44 rows=1 width=50) (actual time=0.004..0.004 rows=1 loops=20)

  • Index Cond: (id = projectclient8.clientid)
51. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.58..19.65 rows=1 width=0) (never executed)

  • Join Filter: (project1_2.id = projectclient3_2.projectid)
  • Filter: ((alternatives: SubPlan 8 or hashed SubPlan 9) OR (project1_2.projectleaderapproverid = 2) OR (projectsharingassignment2_2.userid = 2) OR (clients4_2.clientmanageruserid = 2) OR (clientsharingassignment5_2.userid = 2))
52. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.58..11.93 rows=1 width=12) (never executed)

  • Join Filter: (projectsharingassignment2_2.projectid = project1_2.id)
53. 0.000 0.000 ↓ 0.0 0

Index Scan using project_pkey on project project1_2 (cost=0.42..2.44 rows=1 width=8) (never executed)

  • Index Cond: ("*SELECT* 1".projectid = id)
54. 0.000 0.000 ↓ 0.0 0

Index Only Scan using projectsharingassignment_pkey on projectsharingassignment projectsharingassignment2_2 (cost=0.15..9.35 rows=11 width=8) (never executed)

  • Index Cond: (projectid = "*SELECT* 1".projectid)
  • Heap Fetches: 0
55. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.00..5.25 rows=1 width=12) (never executed)

56. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.84..4.88 rows=1 width=12) (never executed)

57. 0.000 0.000 ↓ 0.0 0

Index Only Scan using uix4pc_projectclienteffectiveend on projectclient projectclient3_2 (cost=0.42..2.44 rows=1 width=8) (never executed)

  • Index Cond: (projectid = "*SELECT* 1".projectid)
  • Heap Fetches: 0
58. 0.000 0.000 ↓ 0.0 0

Index Scan using clients_pkey on clients clients4_2 (cost=0.42..2.44 rows=1 width=8) (never executed)

  • Index Cond: (projectclient3_2.clientid = id)
59. 0.000 0.000 ↓ 0.0 0

Index Scan using ixcsaclientid on clientsharingassignment clientsharingassignment5_2 (cost=0.15..0.29 rows=8 width=8) (never executed)

  • Index Cond: (clientid = clients4_2.id)
60.          

SubPlan (for Nested Loop Left Join)

61. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on project project6_4 (cost=0.42..2.44 rows=1 width=0) (never executed)

  • Index Cond: (id = project1_2.id)
  • Heap Fetches: 0
62. 0.000 0.000 ↓ 0.0 0

Seq Scan on project project6_5 (cost=0.00..80,812.71 rows=994,471 width=4) (never executed)

63. 919.072 2,926.928 ↓ 1.3 994,471 1

Hash Right Join (cost=182,372.44..192,852.76 rows=783,724 width=4) (actual time=2,309.332..2,926.928 rows=994,471 loops=1)

  • Hash Cond: (projectsharingassignment2_3.projectid = project1_3.id)
  • Filter: ((alternatives: SubPlan 11 or hashed SubPlan 12) OR (project1_3.projectleaderapproverid = 2) OR (projectsharingassignment2_3.userid = 2) OR (clients4_3.clientmanageruserid = 2) OR (clientsharingassignment5_3.userid = 2))
64. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on projectsharingassignment projectsharingassignment2_3 (cost=0.00..32.60 rows=2,260 width=8) (actual time=0.003..0.003 rows=0 loops=1)

65. 218.124 1,806.324 ↑ 1.0 994,471 1

Hash (cost=165,085.55..165,085.55 rows=994,471 width=16) (actual time=1,806.324..1,806.324 rows=994,471 loops=1)

  • Buckets: 1,048,576 Batches: 2 Memory Usage: 29,567kB
66. 266.956 1,588.200 ↑ 1.0 994,471 1

Hash Left Join (cost=20,942.38..165,085.55 rows=994,471 width=16) (actual time=200.492..1,588.200 rows=994,471 loops=1)

  • Hash Cond: (projectclient3_3.clientid = clients4_3.id)
67. 455.768 1,121.712 ↑ 1.0 994,471 1

Merge Left Join (cost=0.85..130,470.05 rows=994,471 width=12) (actual time=0.089..1,121.712 rows=994,471 loops=1)

  • Merge Cond: (project1_3.id = projectclient3_3.projectid)
68. 362.502 362.502 ↑ 1.0 994,471 1

Index Scan using project_pkey on project project1_3 (cost=0.42..88,515.49 rows=994,471 width=8) (actual time=0.048..362.502 rows=994,471 loops=1)

69. 303.442 303.442 ↑ 1.0 994,471 1

Index Only Scan using uix4pc_projectclienteffectiveend on projectclient projectclient3_3 (cost=0.42..27,037.49 rows=994,471 width=8) (actual time=0.036..303.442 rows=994,471 loops=1)

  • Heap Fetches: 994,471
70. 48.730 199.532 ↑ 1.0 231,426 1

Hash (cost=18,048.70..18,048.70 rows=231,426 width=12) (actual time=199.532..199.532 rows=231,426 loops=1)

  • Buckets: 262,144 Batches: 1 Memory Usage: 11,089kB
71. 56.430 150.802 ↑ 1.0 231,426 1

Merge Left Join (cost=0.57..18,048.70 rows=231,426 width=12) (actual time=0.048..150.802 rows=231,426 loops=1)

  • Merge Cond: (clients4_3.id = clientsharingassignment5_3.clientid)
72. 94.360 94.360 ↑ 1.0 231,426 1

Index Scan using clients_pkey on clients clients4_3 (cost=0.42..17,415.81 rows=231,426 width=8) (actual time=0.034..94.360 rows=231,426 loops=1)

73. 0.012 0.012 ↓ 0.0 0 1

Index Scan using ixcsaclientid on clientsharingassignment clientsharingassignment5_3 (cost=0.15..34.70 rows=1,570 width=8) (actual time=0.012..0.012 rows=0 loops=1)

74.          

SubPlan (for Hash Right Join)

75. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on project project6_6 (cost=0.42..2.44 rows=1 width=0) (never executed)

  • Index Cond: (id = project1_3.id)
  • Heap Fetches: 0
76. 201.529 201.529 ↑ 1.0 994,471 1

Seq Scan on project project6_7 (cost=0.00..80,812.71 rows=994,471 width=4) (actual time=0.014..201.529 rows=994,471 loops=1)

77. 0.000 0.180 ↑ 1.0 1 20

Limit (cost=4.90..4.90 rows=1 width=525) (actual time=0.009..0.009 rows=1 loops=20)

78. 0.060 0.180 ↑ 1.0 1 20

Sort (cost=4.90..4.90 rows=1 width=525) (actual time=0.009..0.009 rows=1 loops=20)

  • Sort Key: projectclient10.costallocationpercentage DESC, ((clients9.name)::character varying(255)) COLLATE "en_US
  • Sort Method: quicksort Memory: 25kB
79. 0.020 0.120 ↑ 1.0 1 20

Nested Loop (cost=0.84..4.89 rows=1 width=525) (actual time=0.006..0.006 rows=1 loops=20)

80. 0.060 0.060 ↑ 1.0 1 20

Index Scan using uix4pc_projectclienteffectiveend on projectclient projectclient10 (cost=0.42..2.45 rows=1 width=9) (actual time=0.003..0.003 rows=1 loops=20)

  • Index Cond: ((projectid = "*SELECT* 1".projectid) AND (effectivedate <= '2020-09-03'::date) AND (enddate >= '2020-09-03'::date))
81. 0.040 0.040 ↑ 1.0 1 20

Index Scan using clients_pkey on clients clients9 (cost=0.42..2.44 rows=1 width=50) (actual time=0.002..0.002 rows=1 loops=20)

  • Index Cond: (id = projectclient10.clientid)
82. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.58..19.65 rows=1 width=0) (never executed)

  • Join Filter: (project1_4.id = projectclient3_4.projectid)
  • Filter: ((alternatives: SubPlan 15 or hashed SubPlan 16) OR (project1_4.projectleaderapproverid = 2) OR (projectsharingassignment2_4.userid = 2) OR (clients4_4.clientmanageruserid = 2) OR (clientsharingassignment5_4.userid = 2))
83. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.58..11.93 rows=1 width=12) (never executed)

  • Join Filter: (projectsharingassignment2_4.projectid = project1_4.id)
84. 0.000 0.000 ↓ 0.0 0

Index Scan using project_pkey on project project1_4 (cost=0.42..2.44 rows=1 width=8) (never executed)

  • Index Cond: ("*SELECT* 1".projectid = id)
85. 0.000 0.000 ↓ 0.0 0

Index Only Scan using projectsharingassignment_pkey on projectsharingassignment projectsharingassignment2_4 (cost=0.15..9.35 rows=11 width=8) (never executed)

  • Index Cond: (projectid = "*SELECT* 1".projectid)
  • Heap Fetches: 0
86. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.00..5.25 rows=1 width=12) (never executed)

87. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.84..4.88 rows=1 width=12) (never executed)

88. 0.000 0.000 ↓ 0.0 0

Index Only Scan using uix4pc_projectclienteffectiveend on projectclient projectclient3_4 (cost=0.42..2.44 rows=1 width=8) (never executed)

  • Index Cond: (projectid = "*SELECT* 1".projectid)
  • Heap Fetches: 0
89. 0.000 0.000 ↓ 0.0 0

Index Scan using clients_pkey on clients clients4_4 (cost=0.42..2.44 rows=1 width=8) (never executed)

  • Index Cond: (projectclient3_4.clientid = id)
90. 0.000 0.000 ↓ 0.0 0

Index Scan using ixcsaclientid on clientsharingassignment clientsharingassignment5_4 (cost=0.15..0.29 rows=8 width=8) (never executed)

  • Index Cond: (clientid = clients4_4.id)
91.          

SubPlan (for Nested Loop Left Join)

92. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on project project6_8 (cost=0.42..2.44 rows=1 width=0) (never executed)

  • Index Cond: (id = project1_4.id)
  • Heap Fetches: 0
93. 0.000 0.000 ↓ 0.0 0

Seq Scan on project project6_9 (cost=0.00..80,812.71 rows=994,471 width=4) (never executed)

94. 1,134.031 2,936.479 ↓ 1.3 994,471 1

Hash Right Join (cost=182,372.44..192,852.76 rows=783,724 width=4) (actual time=2,299.396..2,936.479 rows=994,471 loops=1)

  • Hash Cond: (projectsharingassignment2_5.projectid = project1_5.id)
  • Filter: ((alternatives: SubPlan 18 or hashed SubPlan 19) OR (project1_5.projectleaderapproverid = 2) OR (projectsharingassignment2_5.userid = 2) OR (clients4_5.clientmanageruserid = 2) OR (clientsharingassignment5_5.userid = 2))
95. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on projectsharingassignment projectsharingassignment2_5 (cost=0.00..32.60 rows=2,260 width=8) (actual time=0.004..0.004 rows=0 loops=1)

96. 221.396 1,802.444 ↑ 1.0 994,471 1

Hash (cost=165,085.55..165,085.55 rows=994,471 width=16) (actual time=1,802.443..1,802.444 rows=994,471 loops=1)

  • Buckets: 1,048,576 Batches: 2 Memory Usage: 29,567kB
97. 253.243 1,581.048 ↑ 1.0 994,471 1

Hash Left Join (cost=20,942.38..165,085.55 rows=994,471 width=16) (actual time=204.293..1,581.048 rows=994,471 loops=1)

  • Hash Cond: (projectclient3_5.clientid = clients4_5.id)
98. 444.678 1,124.478 ↑ 1.0 994,471 1

Merge Left Join (cost=0.85..130,470.05 rows=994,471 width=12) (actual time=0.083..1,124.478 rows=994,471 loops=1)

  • Merge Cond: (project1_5.id = projectclient3_5.projectid)
99. 367.088 367.088 ↑ 1.0 994,471 1

Index Scan using project_pkey on project project1_5 (cost=0.42..88,515.49 rows=994,471 width=8) (actual time=0.046..367.088 rows=994,471 loops=1)

100. 312.712 312.712 ↑ 1.0 994,471 1

Index Only Scan using uix4pc_projectclienteffectiveend on projectclient projectclient3_5 (cost=0.42..27,037.49 rows=994,471 width=8) (actual time=0.033..312.712 rows=994,471 loops=1)

  • Heap Fetches: 994,471
101. 203.327 203.327 ↑ 1.0 231,426 1

Hash (cost=18,048.70..18,048.70 rows=231,426 width=12) (actual time=203.327..203.327 rows=231,426 loops=1)

  • Buckets: 262,144 Batches: 1 Memory Usage: 11,089kB