#postgresql

sql

PostgreSQL

Create index in background

CREATE INDEX CONCURRENTLY IDX_MY_TABLE_ID_MY_COLUMN
    ON MY_TABLE (ID, MY_COLUMN);

Check progress of index creation:

docker compose exec postgres psql --username=user --dbname=database

SELECT
    pid,
    phase,
    lockers_total,
    lockers_done,
    current_locker_pid,
    blocks_total,
    blocks_done,
    tuples_total,
    tuples_done
FROM pg_stat_progress_create_index;