Postgres Pro
Downloads
Home   >   mailing lists

finding queries doing sequential search - Mailing list pgsql-admin

From wambacher@posteo.de
Subject finding queries doing sequential search
Date
Msg-id 6dd2fe53-a93d-a2ca-05aa-325921333dac@posteo.de
Whole thread Raw
Responses Re: finding queries doing sequential search  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: finding queries doing sequential search  (Phil Frost <phil@postmates.com>)
Re: finding queries doing sequential search  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-admin
Tree view

Hi,

i have a very big table (PostGIS OpenStreetMap data, but that does not mapper) with about 380 million records and a size of 275 GB + Indices. Permanently updated and growing.

Of course i enabled autovacuum.

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.

Is there a way/trick do this?

Regards
walter

--
My projects:

Admin Boundaries of the World
Missing Boundaries
Emergency Map
Postal Code Map (Germany only)
Fools (QA for zipcodes in Germany)
Postcode Boundaries of Germany
Attachment

pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: pg_attribute getting bloated in size
Next
From: Tom Lane
Date:
Subject: Re: finding queries doing sequential search