SELECT ccc.logger_date,
       ccc.agg,
(SELECT string_agg( bbb.logger_date || ' ' || bbb.indice || ',' || bbb.parameter,';') AS agg_aa
 FROM
(SELECT  distinct ON (first_value( ind_parameter) OVER (partition by ind_parameter ORDER BY  logger_date))
first_value( ind_parameter) OVER (partition by ind_parameter ORDER BY  logger_date) AS indice,
parameter,logger_date
FROM logger
WHERE system_id = '1234-56789'
AND logger_date > ccc.logger_date
AND ind_parameter in ('1','2', '3', '4', '5', '6', '7', '8', '9', '10', '13', '14')
AND parameter IS NOT NULL ) bbb
 )
FROM
(SELECT logger_date, string_agg(ind_parameter || ','|| parameter,';') AS agg, system_id
FROM logger
WHERE system_id = '1234-56789'
AND ind_parameter in ('1','2', '3', '4', '5', '6', '7', '8', '9', '10', '13', '14')
AND parameter IS NOT NULL group by  logger_date, system_id
order by logger_date) ccc;

Subquery Scan on aaa  (cost=0.42..238917116.65 rows=49626 width=104) (actual time=121.370..2504513.471 rows=59651 loops=1)
   ->  GroupAggregate  (cost=0.42..12255.07 rows=49626 width=83) (actual time=0.043..894.271 rows=59651 loops=1)
         Group Key: logger_tmp.logger_date, logger_tmp.system_id
         ->  Index Scan using logger_tmp_logger_date_idx on logger_tmp  (cost=0.42..10298.19 rows=80833 width=26) (actual time=0.019..310.172 rows=87849 loops=1)
               Filter: ((parameter IS NOT NULL) AND ((system_id)::text = '1234-56789'::text) AND ((ind_parameter)::text = ANY ('{1,2,3,4,5,6,7,8,9,10,13,14}'::text[])))
               Rows Removed by Filter: 30334
   SubPlan 1
     ->  Aggregate  (cost=4814.09..4814.10 rows=1 width=32) (actual time=41.953..41.954 rows=1 loops=59651)
           ->  Bitmap Heap Scan on logger_tmp b  (cost=738.49..4350.74 rows=26477 width=15) (actual time=6.629..39.276 rows=1944 loops=59651)
                 Recheck Cond: (logger_date > aaa.logger_date)
                 Filter: (((system_id)::text = '1234-56789'::text) AND ((ind_parameter)::text > ANY ((aaa.arr)::text[])) AND ((ind_parameter)::text = ANY ('{1,2,3,4,5,6,7,8,9,10,13,14}'::text[])))
                 Rows Removed by Filter: 55358
                 Heap Blocks: exact=62729157
                 ->  Bitmap Index Scan on logger_tmp_logger_date_idx  (cost=0.00..731.87 rows=39394 width=0) (actual time=6.396..6.396 rows=57302 loops=59651)
                       Index Cond: (logger_date > aaa.logger_date)
 Planning time: 0.869 ms
 Execution time: 2504554.579 ms
(17 rows)

VACUUM automatique de la table « mesure » : parcours d'index : 1
    pages : 0 supprimées, 512002 restantes
    lignes : 854702 supprimées, 29992847 restantes, 2301082 sont mortes mais non supprimables
    utilisation des tampons : 766926 lus dans le cache, 733287 lus hors du cache, 197832 modifiés
    taux moyen de lecture : 12.401 Mo/s, taux moyen d'écriture : 3.346 Mo/s

ERROR:  could not establish connection
DÉTAIL : FATAL:  password authentication failed for user "green01"
FATAL:  password authentication failed for user "green01"

CONTEXTE : SQL statement "SELECT dblink_connect('base_log','db_log')"
PL/pgSQL function p_log(text,text) line 18 at PERFORM
SQL statement "SELECT P_LOG('FIN ERREUR : ' || CHR(10) || sqlstate||' - '||sqlerrm,'PROCEDURE' )"
PL/pgSQL function PROCEDURE(bigint) line 233 at PERFORM