What will be the approximate downtime for indexing a column in psql
You can create indexes concurrently to prevent locks.
CREATE INDEX CONCURRENTLY sales_quantity_index ON sales_table (quantity);

Docs