{ "Plan": { "Node Type": "Limit", "Startup Cost": 0.43, "Total Cost": 27.84, "Plan Rows": 10, "Plan Width": 172, "Actual Startup Time": 0.117, "Actual Total Time": 0.135, "Actual Rows": 10, "Actual Loops": 1, "Output": ["u.id", "u.name", "u.email", "p.title", "p.created_at"], "Plans": [ { "Node Type": "Nested Loop", "Parent Relationship": "Outer", "Join Type": "Inner", "Startup Cost": 0.43, "Total Cost": 5723.43, "Plan Rows": 2030, "Plan Width": 172, "Actual Startup Time": 0.115, "Actual Total Time": 0.130, "Actual Rows": 10, "Actual Loops": 1, "Output": ["u.id", "u.name", "u.email", "p.title", "p.created_at"], "Inner Unique": true, "Join Filter": "(p.user_id = u.id)", "Rows Removed by Join Filter": 40, "Plans": [ { "Node Type": "Index Scan", "Parent Relationship": "Outer", "Scan Direction": "Forward", "Index Name": "posts_created_at_idx", "Relation Name": "posts", "Alias": "p", "Schema": "public", "Startup Cost": 0.29, "Total Cost": 22.07, "Plan Rows": 50, "Plan Width": 44, "Actual Startup Time": 0.059, "Actual Total Time": 0.072, "Actual Rows": 50, "Actual Loops": 1, "Output": ["p.id", "p.title", "p.content", "p.created_at", "p.user_id"], "Index Cond": "(posts.created_at IS NOT NULL)", "Rows Removed by Index Recheck": 0, "Heap Fetches": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Inner", "Scan Direction": "Forward", "Index Name": "users_pkey", "Relation Name": "users", "Alias": "u", "Schema": "public", "Startup Cost": 0.14, "Total Cost": 0.16, "Plan Rows": 1, "Plan Width": 128, "Actual Startup Time": 0.001, "Actual Total Time": 0.001, "Actual Rows": 1, "Actual Loops": 50, "Output": ["u.id", "u.name", "u.email", "u.created_at", "u.updated_at"], "Index Cond": "(users.id = p.user_id)", "Rows Removed by Index Recheck": 0, "Heap Fetches": 0 } ] } ] }, "Planning Time": 1.301, "Triggers": [], "Execution Time": 0.216 }