Changes between Version 1 and Version 2 of P9

Timestamp:

05/25/26 21:12:06 (16 hours ago)

Author:

211099

Comment:

--

P9

@@ -11 +11 @@
 Complex reporting query that aggregates per-story statistics grouped by calendar quarter, then computes engagement rates, quarter-over-quarter growth percentages, and per-quarter rankings using window functions across three CTEs.
 
-{{{ 
+{{{
 WITH quarterly_story_stats AS (
     SELECT
@@ -269 +269 @@
 
 == Indexes for this queries
-
+{{{
 CREATE INDEX idx_story_created_at
     ON story(story_created_at);
@@ -294 +294 @@
 
 CREATE INDEX idx_comment_story_id ON comment(story_id);
-
-
 }}}
 
@@ -304 +302 @@
 ANALYZE likes;
 ANALYZE comment;
-
+}}}
 |QUERY PLAN                                                                                                                                                                                                                                                             |
 |-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|