+------------------------------------------------------------------+
| QUERY PLAN |
+------------------------------------------------------------------+
| <explain xmlns="http://www.postgresql.org/2009/explain"> +|
| <Query> +|
| <Plan> +|
| <Node-Type>Nested Loop</Node-Type> +|
| <Parallel-Aware>false</Parallel-Aware> +|
| <Join-Type>Inner</Join-Type> +|
| <Startup-Cost>0.00</Startup-Cost> +|
| <Total-Cost>2017.80</Total-Cost> +|
| <Plan-Rows>15</Plan-Rows> +|
| <Plan-Width>133</Plan-Width> +|
| <Actual-Startup-Time>0.034</Actual-Startup-Time> +|
| <Actual-Total-Time>1.951</Actual-Total-Time> +|
| <Actual-Rows>15</Actual-Rows> +|
| <Actual-Loops>1</Actual-Loops> +|
| <Inner-Unique>false</Inner-Unique> +|
| <Plans> +|
| <Plan> +|
| <Node-Type>Seq Scan</Node-Type> +|
| <Parent-Relationship>Outer</Parent-Relationship> +|
| <Parallel-Aware>false</Parallel-Aware> +|
| <Relation-Name>users</Relation-Name> +|
| <Alias>u</Alias> +|
| <Startup-Cost>0.00</Startup-Cost> +|
| <Total-Cost>41.40</Total-Cost> +|
| <Plan-Rows>1</Plan-Rows> +|
| <Plan-Width>129</Plan-Width> +|
| <Actual-Startup-Time>0.012</Actual-Startup-Time> +|
| <Actual-Total-Time>0.079</Actual-Total-Time> +|
| <Actual-Rows>1</Actual-Rows> +|
| <Actual-Loops>1</Actual-Loops> +|
| <Filter>(username = 'depesz'::text)</Filter> +|
| <Rows-Removed-by-Filter>1231</Rows-Removed-by-Filter> +|
| </Plan> +|
| <Plan> +|
| <Node-Type>Seq Scan</Node-Type> +|
| <Parent-Relationship>Inner</Parent-Relationship> +|
| <Parallel-Aware>false</Parallel-Aware> +|
| <Relation-Name>part_0</Relation-Name> +|
| <Alias>p</Alias> +|
| <Startup-Cost>0.00</Startup-Cost> +|
| <Total-Cost>1976.25</Total-Cost> +|
| <Plan-Rows>15</Plan-Rows> +|
| <Plan-Width>17</Plan-Width> +|
| <Actual-Startup-Time>0.021</Actual-Startup-Time> +|
| <Actual-Total-Time>1.869</Actual-Total-Time> +|
| <Actual-Rows>15</Actual-Rows> +|
| <Actual-Loops>1</Actual-Loops> +|
| <Filter>(added_by = 'depesz'::text)</Filter> +|
| <Rows-Removed-by-Filter>13205</Rows-Removed-by-Filter>+|
| </Plan> +|
| </Plans> +|
| </Plan> +|
| <Planning-Time>0.040</Planning-Time> +|
| <Triggers> +|
| </Triggers> +|
| <Execution-Time>1.960</Execution-Time> +|
| </Query> +|
| </explain> |
+------------------------------------------------------------------+
(1 row)