Changes between Version 2 and Version 3 of App

Timestamp:

09/04/25 23:21:54 (4 days ago)

Author:

163080

Comment:

--

App

@@ -38 +38 @@
   - `idx_invoice_notifications_invoice_id`: Speeds up notification retrieval
   - `idx_invoice_notifications_processed`: Partial index for unprocessed notifications
+
+- Using `EXPLAIN` on the `Client` table
+
+  - Before creating the index:
+
+{{{
+EXPLAIN ANALYZE SELECT * FROM "Client" WHERE email = 'client12@example.com';
+}}}
+
+  - After adding index and creating 1000 rows:
+{{{
+EXPLAIN ANALYZE SELECT * FROM "Client" WHERE email = 'client12@example.com';
+}}}
+
+{{{
+Index Scan using idx_client_email on "Client"  (cost=0.28..8.29 rows=1 width=303)
+  Index Cond: (email = 'client12@example.com'::text)
+}}}