【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

posted @ 2024-03-03 11:38  DBAGPT  阅读(36)  评论(0编辑  收藏  举报