The Perl Toolchain Summit 2025 Needs You: You can help 🙏 Learn more

╔════════════════════════════════════════════════════╗
║ QUERY PLAN ║
╠════════════════════════════════════════════════════╣
║ [ ↵║
║ { ↵║
║ "Plan": { ↵║
║ "Node Type": "Nested Loop", ↵║
║ "Parallel Aware": false, ↵║
║ "Join Type": "Inner", ↵║
║ "Startup Cost": 0.00, ↵║
║ "Total Cost": 2017.80, ↵║
║ "Plan Rows": 15, ↵║
║ "Plan Width": 133, ↵║
║ "Actual Startup Time": 0.044, ↵║
║ "Actual Total Time": 2.234, ↵║
║ "Actual Rows": 15, ↵║
║ "Actual Loops": 1, ↵║
║ "Inner Unique": false, ↵║
║ "Plans": [ ↵║
║ { ↵║
║ "Node Type": "Seq Scan", ↵║
║ "Parent Relationship": "Outer", ↵║
║ "Parallel Aware": false, ↵║
║ "Relation Name": "users", ↵║
║ "Alias": "u", ↵║
║ "Startup Cost": 0.00, ↵║
║ "Total Cost": 41.40, ↵║
║ "Plan Rows": 1, ↵║
║ "Plan Width": 129, ↵║
║ "Actual Startup Time": 0.015, ↵║
║ "Actual Total Time": 0.080, ↵║
║ "Actual Rows": 1, ↵║
║ "Actual Loops": 1, ↵║
║ "Filter": "(username = 'depesz'::text)",↵║
║ "Rows Removed by Filter": 1231 ↵║
║ }, ↵║
║ { ↵║
║ "Node Type": "Seq Scan", ↵║
║ "Parent Relationship": "Inner", ↵║
║ "Parallel Aware": false, ↵║
║ "Relation Name": "part_0", ↵║
║ "Alias": "p", ↵║
║ "Startup Cost": 0.00, ↵║
║ "Total Cost": 1976.25, ↵║
║ "Plan Rows": 15, ↵║
║ "Plan Width": 17, ↵║
║ "Actual Startup Time": 0.028, ↵║
║ "Actual Total Time": 2.151, ↵║
║ "Actual Rows": 15, ↵║
║ "Actual Loops": 1, ↵║
║ "Filter": "(added_by = 'depesz'::text)",↵║
║ "Rows Removed by Filter": 13205 ↵║
║ } ↵║
║ ] ↵║
║ }, ↵║
║ "Planning Time": 0.046, ↵║
║ "Triggers": [ ↵║
║ ], ↵║
║ "Execution Time": 2.244 ↵║
║ } ↵║
║ ] ║
╚════════════════════════════════════════════════════╝
(1 row)