TIL how to check index creation progress in postgres
Published on September 17, 2024
SELECT (blocks_done::numeric / blocks_total::numeric) * 100 AS percentage_done FROM pg_stat_progress_create_index;
Got this from Stackoverflow: https://stackoverflow.com/a/78640729
Yes, it's from the good old stackoverflow :)