pgsql統計クエリーを記録

SELECT "ehi"."houses_id"                                         AS   id,
       "ehi"."houses_name"                                       AS     ,
       "ehi"."developer"                                         AS    ,
       Concat_ws('--', "ehi"."min_acreage", "ehi"."max_acreage") AS   ,
       CASE
         WHEN "ehi"."property" = 'house'THEN '  '
         WHEN "ehi"."property" = 'business' THEN '  '
         WHEN "ehi"."property" = 'villa' THEN '  '
         WHEN "ehi"."property" = 'offices' THEN '   '
         WHEN "ehi"."property" = 'shop' THEN '  '
         WHEN "ehi"."property" = 'apartment' THEN '  '
         WHEN "ehi"."property" = 'synthesize' THEN '   '
         WHEN "ehi"."property" = 'enterprise' THEN '    '
         WHEN "ehi"."property" = 'affordable' THEN '     '
         WHEN "ehi"."property" = 'foreign-style-house' THEN '  '
         WHEN "ehi"."property" = 'two-limit-house' THEN '   '
         WHEN "ehi"."property" = 'commodity-house' THEN '      '
         ELSE '  '
       END                                                       AS     ,
       CASE
         WHEN "ehi"."source" = 0 THEN '  '
         WHEN "ehi"."source" = 1 THEN '  '
         WHEN "ehi"."source" = 2 THEN '   '
         ELSE '  '
       END                                                       AS     ,
       CASE
        
         WHEN "ehi"."is_show" = 1
              AND "ehi"."check_state" = 1 THEN '   '
       END                                                       AS   ,
       "ebi"."broker_name"                                       AS       ,
       "ebi"."broker_mobile"                                     AS          ,
       "ehc".counselor_count                                     AS     ,
       "edc".type_count                                          AS     ,
       "ea"."name"                                               AS    ,
       "eb"."name"                                               AS    ,
       "ec"."name"                                               AS    ,
       To_timestamp("ehi"."create_time")                         AS     ,
       "ehi"."houses_address"                                    AS     ,
       CASE
         WHEN "return_type" = 1 THEN '  '
                                     || "return_percentage"
                                     || '%'
         WHEN "return_type" = 0 THEN return_price
                                     || '-'
                                     || return_max_price
       END                                                       AS   ,
       CASE
         WHEN "houses_unit" = '  / ' THEN houses_min_price
                                                || '-'
                                                || houses_max_price
                                                || '  / '
         WHEN "houses_unit" = '  ' THEN houses_min_price
                                            || '-'
                                            || houses_max_price
                                            || '  '
         WHEN "houses_unit" = ' /  ' THEN houses_min_price
                                                || '-'
                                                || houses_max_price
                                                || ' /  '
         WHEN "houses_unit" = ' ' THEN houses_min_price
                                         || '-'
                                         || houses_max_price
                                         || ' '
       END                                                       AS   ,
       "ehi"."return_rule"                                       AS     
FROM   ex_houses_info ehi
       LEFT JOIN ex_broker_info ebi
              ON ehi.uid = ebi.broker_uid
       LEFT JOIN (SELECT "house_id",
                         Count(*) AS counselor_count
                  FROM   "ex_houses_counselor"
                  WHERE  "is_freeze" = 0
                  GROUP  BY "house_id") AS "ehc"
              ON "ehi"."houses_id" = "ehc"."house_id"
       LEFT JOIN (SELECT "house_id",
                         Count(*) AS type_count
                  FROM   "ex_house_type"
                  GROUP  BY "house_id") AS "edc"
              ON "ehi"."houses_id" = "edc"."house_id"
       LEFT JOIN ex_area ea
              ON ehi.house_province = ea.id
       LEFT JOIN ex_area eb
              ON ehi.houses_city = eb.id
       LEFT JOIN ex_area ec
              ON ehi.houses_location = ec.id