wambacher@posteo.de writes:
> The log shows me 8.2 Mio index scans (iscan), which is fine, and right
> now 424 sequential scans (sscan) for planet_osm_polygon. see attached image.
> I want to locate the query doing this stuff but EXPLAIN won't help
> because most querys are dynamicly created.
auto_explain might help. Or you could just log_min_duration_statement
to capture queries that are running long.
regards, tom lane