【PG】pg_stat_progress_create_index - (concurrently)索引创建预估时间
-- 查看正在执行index creation语句的持续时间,每隔2秒输出一次
SELECT now()::TIME(0), a.query, p.phase, p.blocks_total, p.blocks_done, p.tuples_total, p.tuples_done FROM pg_stat_progress_create_index p JOIN pg_stat_activity a ON p.pid = a.pid \watch 2