[Tile-serving] [openstreetmap/osm2pgsql] Show index progress (Discussion #1797)

[mboeringa]

Despite improvements in indexing speed in recent releases of PostgreSQL, indexing remains one of the most time consuming steps of the osm2pgsql import.

It would therefor be nice if there was some form of basic indexing progress indication. This is in fact possible by querying the 'pg_stat_progress_create_index' system view of PostgreSQL, e.g. by a query something like this:

`SELECT blocks_total,blocks_done FROM pg_catalog.pg_stat_progress_create_index WHERE datname = '<DATABASE>' AND relid = '<TABLE>'::regclass`

I have personally used such query in a post-osm2pgsql processing task to show block progress, and it is really nice to have some indication of progress and a rough indication when something might be finished.

-- 
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/discussions/1797
You are receiving this because you are subscribed to this thread.

Message ID: <openstreetmap/osm2pgsql/repo-discussions/1797 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20221018/bfd80182/attachment.htm>