[OSM-dev] about Carto and SQL

[Paul Norman]

On 3/20/2018 9:13 AM, sav123 wrote:
> I hope to be able to grab enough information to partition some or all 
> the postgresql tables and to publish the resulting comparison boards.
>
> I know that it is possible to setup logs and to check them, but this 
> method may miss rare calls ...

Kompza covered the variables you mentioned, but I if you're looking at 
benchmarking, I recommend you set up the full rendering stack rather 
than trying to generate queries yourself. The latter can be tricky to 
get right, and you have to handle parallelism the same as the full stack 
to get meaningful results. It's just easier to use renderd and feed it a 
list of tiles with render_list than to write code that will take that 
list, generate SQL, and run it.