select  
      coalesce(r19383758.pdesc, subq_2987807.c0) as c0, 
      subq_2987810.c0 as c1, 
      r19383837.id as c2, 
      r19383759.expr as c3, 
      14 as c4, 
      subq_2987807.c2 as c5, 
      r19383759.expr as c6, 
      r19383876.c as c7, 
      subq_2987811.c0 as c8, 
      r19383866.ten as c9, 
      r19383867.a as c10, 
      r19383863.annualsal as c11, 
      subq_2987807.c2 as c12, 
      r19383875.unique2 as c13, 
      subq_2987807.c2 as c14
    from 
      public.rtest_person as r19383758
          right join public.query as r19383759
          on (r19383758.pdesc = r19383759.expr )
        right join public.spgist_text_tbl as r19383837
            inner join (select  
                  subq_2987808.c2 as c0, 
                  r19383838.catalog_name as c1, 
                  subq_2987808.c0 as c2
                from 
                  information_schema.information_schema_catalog_name as r19383838,
                  lateral (select  
                        r19383839.a as c0, 
                        r19383839.b as c1, 
                        r19383839.d as c2
                      from 
                        public.clstr_tst_inh as r19383839
                      where EXISTS (
                        select  
                            r19383840.sl_name as c0
                          from 
                            public.shoelace_obsolete as r19383840
                          where (15 <> 3) 
                            or ((r19383840.sl_name is not NULL) 
                              and (r19383840.sl_len is not NULL))
                          fetch first 154 rows only)) as subq_2987808
                where false
                fetch first 95 rows only) as subq_2987807
            on (r19383837.t = subq_2987807.c0 )
          right join public.dropcolumnanother as r19383862
                right join public.toyemp as r19383863
                on (r19383862.e = r19383863.age )
              left join public.onek2 as r19383866
                inner join public.tab1 as r19383867
                on (r19383866.ten = r19383867.a )
              on (r19383862.e = r19383866.unique1 )
            right join public.tenk1 as r19383875
              right join public.rtest_order2 as r19383876
              on (r19383875.unique1 = r19383876.a )
            on (r19383863.name = r19383876.c )
          on (r19383837.id = r19383862.b )
        on (r19383759.expr = r19383876.c ),
      lateral (select  
            r19383877.f1 as c0
          from 
            public.dupindexcols as r19383877
          where r19383877.id is not NULL) as subq_2987810,
      lateral (select  
            r19383878.location as c0
          from 
            public.stud_emp as r19383878
          where r19383878.name ~>=~ r19383878.name) as subq_2987811
    where r19383863.name is NULL
    fetch first 103 rows only;