JSON three level, PostgreSQL

Language: Layout:

DROP TABLE IF EXISTS table_1 ;
DROP TABLE IF EXISTS table_2 ;
DROP TABLE IF EXISTS table_3 ;

CREATE TABLE table_1
(
    table_1_id integer PRIMARY KEY,
    somedata text
) ;

INSERT INTO table_1 VALUES (1,'somedata1') ;

CREATE TABLE table_2
(
    table_2_id integer PRIMARY KEY,
    table_1_id integer NOT NULL REFERENCES table_1 (table_1_id),
    somedata text
) ;

INSERT INTO table_2 VALUES (1, 1, 'somedata21') ;
INSERT INTO table_2 VALUES (2, 1, 'somedata22') ;

CREATE TABLE table_3
(
    table_3_id integer PRIMARY KEY,
    table_2_id integer NOT NULL REFERENCES table_2 (table_2_id),
    somedata text
) ;

INSERT INTO table_3 VALUES (1, 1, 'somedata3');
INSERT INTO table_3 VALUES (2, 1, 'somedata3');
INSERT INTO table_3 VALUES (3, 2, 'somedata3');
INSERT INTO table_3 VALUES (4, 2, 'somedata3');

SELECT
        row_to_json (r1.*)
    FROM
        (
            SELECT 
                table_1_id, 
                somedata,
                array(
                    SELECT
                        row_to_json (r2.*)
                    FROM
                    (
                    SELECT 
                            table_2_id, 
                            somedata,
                            array(
                                SELECT
                                    row_to_json(r3.*, true)
                                FROM
                                (
                                    SELECT
                                        table_3.table_3_id,
                                        table_3.somedata
                                    FROM
                                        table_3
                                    WHERE
                                        table_3.table_2_id = table_2.table_2_id
                                    ORDER BY
                                        table_3_id
                                ) r3
                                
                            ) AS table_2_data
                      FROM 
                            table_2  
                     WHERE 
                            table_2.table_1_id = table_1.table_1_id 
                     ORDER BY 
                            table_2_id
                    ) r2
               ) AS table_2_data
            FROM 
                table_1
        ) AS r1


absolute service time: 0,46 sec