Does render time include postgres query time?

Hello,

I've set up my own tile server (as in the tutorial on the https://switch2osm.org/manually-building-a-tile-server-18-04-lts/) and now I have a few questions about optimization (I guess).

So, the main question is, does the render time:

renderd[5037]: DEBUG: START TILE ajt 17 71632-71639 43864-43871, new metatile renderd[5037]: DEBUG: DONE TILE ajt 17 71632-71639 43864-43871 in 3.534 seconds

include the time that's needed by postgres to complete the queries:

execution time 2038.937 ms, query: SELECT ST_AsBinary("way") AS geom,"feature","link","service" FROM (SELECT way, (CASE WHEN feature IN ('highway_motorway_link', 'highway_trunk_link', 'highway_prima ry_link', 'highway_secondary_link', 'highway_tertiary_link') THEN substr(feature, 0, length(feat ure)-4) ELSE feature END) AS feature, [...]

If yes, then if there's better CartoCss version that has queries optimized for the better indices usage?

renderd time

asked 19 Aug '19, 15:27

januzi
56●1●1●4
accept rate: 0%

Be the first one to answer this question!

toggle preview

community wiki:

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

renderd ×105
time ×29

question asked: 19 Aug '19, 15:27

question was seen: 580 times

last updated: 19 Aug '19, 15:27

Does render time include postgres query time?

Follow this question

Related questions