wambacher@xxxxxxxxx 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
