Changes between Version 3 and Version 4 of Indexes

Timestamp:

02/04/26 20:10:20 (4 days ago)

Author:

233194

Comment:

--

Indexes

@@ -178 +178 @@
 
 === Scenario 4: Admin Panel - Pending Approvals ===
-Without partial index:
-Index Scan using idx_build_approved_date on build b
-  Index Cond: (is_approved = false)
-  Buffers: shared hit=150
+Without partial index: \\
+Index Scan using idx_build_approved_date on build b \\
+Index Cond: (is_approved = false) \\
+Buffers: shared hit=150 \\
 Execution Time: 0.351 ms \\
 
-With partial index:
-Index Scan using idx_build_pending_date on build b
-  Buffers: shared hit=68 read=2
+With partial index: \\
+Index Scan using idx_build_pending_date on build b \\
+Buffers: shared hit=68 read=2 \\
 Execution Time: 0.219 ms \\
 
@@ -194 +194 @@
 === Scenario 7: Top Performing Components Report ===
 
-Without indexes:
-Buffers: shared hit=7684
-Planning Time: 0.021 ms
-Execution Time: 506.953 ms
-
-With indexes:
-Buffers: shared hit=6379 read=351
-Planning Time: 0.022 ms
-Execution Time: 468.190 ms
+Without indexes: \\
+Buffers: shared hit=7684 \\
+Planning Time: 0.021 ms \\
+Execution Time: 506.953 ms \\
+
+With indexes: \\
+Buffers: shared hit=6379 read=351 \\
+Planning Time: 0.022 ms \\
+Execution Time: 468.190 ms \\
 
 Result: The date index improved query performance, while not much, still a modest improvement reducing it from 506.953ms to 468.190ms. \\
@@ -208 +208 @@
 === Scenario 8: User Reputation Leaderboard Report ===
 
-Without indexes:
-Buffers: shared hit=142884 dirtied=1, temp read=495 written=849
-Planning Time: 0.029 ms
-Execution Time: 553.368 ms
-
-With indexes:
-Buffers: shared hit=142892 read=1, temp read=231 written=584
-Planning Time: 0.022 ms
-Execution Time: 345.192 ms
+Without indexes: \\
+Buffers: shared hit=142884 dirtied=1, temp read=495 written=849 \\
+Planning Time: 0.029 ms \\
+Execution Time: 553.368 ms \\
+
+With indexes: \\
+Buffers: shared hit=142892 read=1, temp read=231 written=584 \\
+Planning Time: 0.022 ms \\
+Execution Time: 345.192 ms \\
 
 Result: Here the improvement is much more noticeable than on Scenario 7, reducing the time from 553.368ms to 345.192ms. \\
@@ -222 +222 @@
 === Scenario 9: Budget Tier Popularity Report ===
 
-Without indexes:
-Buffers: shared hit=1366 read=30
-Planning Time: 0.020 ms
-Execution Time: 131.234 ms
-
-With indexes:
-Buffers: shared hit=1396
-Planning Time: 0.029 ms
-Execution Time: 125.615 ms
+Without indexes: \\
+Buffers: shared hit=1366 read=30 \\
+Planning Time: 0.020 ms \\
+Execution Time: 131.234 ms \\
+
+With indexes: \\
+Buffers: shared hit=1396 \\
+Planning Time: 0.029 ms \\
+Execution Time: 125.615 ms \\
 
 Result: Modest improvement, but the index still helped out with unnecessary reads, reducing time from 131.234ms to 125.615ms. \\