The Perl and Raku Conference 2025: Greenville, South Carolina - June 27-29 Learn more

DEPESZ / Pg-Explain-2.8 / t / 16-ctes / 2-xml.expect 

            

              
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
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87

              
{
    'actual_loops'           => '1',
    'actual_rows'            => '2',
    'actual_time_first'      => '0.006',
    'actual_time_last'       => '0.01',
    'estimated_row_width'    => '4',
    'estimated_rows'         => '2',
    'estimated_startup_cost' => '0.02',
    'estimated_total_cost'   => '0.06',
    'is_analyzed'            => 1,
    'cte_order'              => [ 'cte_1', 'cte_2' ],
    'ctes'                   => {
        'cte_1' => {
            'actual_loops'           => '1',
            'actual_rows'            => '1',
            'actual_time_first'      => '0.001',
            'actual_time_last'       => '0.001',
            'estimated_row_width'    => '0',
            'estimated_rows'         => '1',
            'estimated_startup_cost' => '0',
            'estimated_total_cost'   => '0.01',
            'is_analyzed'            => 1,
            'type'                   => 'Result'
        },
        'cte_2' => {
            'actual_loops'           => '1',
            'actual_rows'            => '1',
            'actual_time_first'      => '0.001',
            'actual_time_last'       => '0.002',
            'estimated_row_width'    => '0',
            'estimated_rows'         => '1',
            'estimated_startup_cost' => '0',
            'estimated_total_cost'   => '0.01',
            'is_analyzed'            => 1,
            'type'                   => 'Result'
        },
    },
    'sub_nodes' => [
        {
            'actual_loops'           => '1',
            'actual_rows'            => '2',
            'actual_time_first'      => '0.005',
            'actual_time_last'       => '0.008',
            'estimated_row_width'    => '4',
            'estimated_rows'         => '2',
            'estimated_startup_cost' => '0',
            'estimated_total_cost'   => '0.04',
            'is_analyzed'            => 1,
            'sub_nodes'              => [
                {
                    'actual_loops'           => '1',
                    'actual_rows'            => '1',
                    'actual_time_first'      => '0.005',
                    'actual_time_last'       => '0.006',
                    'estimated_row_width'    => '4',
                    'estimated_rows'         => '1',
                    'estimated_startup_cost' => '0',
                    'estimated_total_cost'   => '0.02',
                    'is_analyzed'            => 1,
                    'type'                   => 'CTE Scan',
                    'scan_on' => {
                        'cte_name' => 'cte_1',
                        'cte_alias' => 'cte_1',
                    },
                },
                {
                    'actual_loops'           => '1',
                    'actual_rows'            => '1',
                    'actual_time_first'      => '0.001',
                    'actual_time_last'       => '0.002',
                    'estimated_row_width'    => '4',
                    'estimated_rows'         => '1',
                    'estimated_startup_cost' => '0',
                    'estimated_total_cost'   => '0.02',
                    'is_analyzed'            => 1,
                    'type'                   => 'CTE Scan',
                    'scan_on' => {
                        'cte_name' => 'cte_2',
                        'cte_alias' => 'cte_2',
                    },
                }
            ],
            'type' => 'Append'
        }
    ],
    'type' => 'Result'
}