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

DEPESZ / Pg-Explain-2.8 / t / 50-psql-frames.d / json-2-aligned-old-ascii-double-double-double.plan 

            

              
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63

              
+----------------------------------------------------+
|                     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.037,                |
|       "Actual Total Time": 1.905,                  |
|       "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.013,            |
|           "Actual Total Time": 0.077,              |
|           "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.023,            |
|           "Actual Total Time": 1.825,              |
|           "Actual Rows": 15,                       |
|           "Actual Loops": 1,                       |
|           "Filter": "(added_by = 'depesz'::text)", |
|           "Rows Removed by Filter": 13205          |
|         }                                          |
|       ]                                            |
|     },                                             |
|     "Planning Time": 0.041,                        |
|     "Triggers": [                                  |
|     ],                                             |
|     "Execution Time": 1.913                        |
|   }                                                |
| ]                                                  |
+----------------------------------------------------+
(1 row)