pgstattuple_approx for toasted table

From: Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com>
To: PostgreSQL mailing lists <pgsql-performance(at)postgresql(dot)org>
Subject: pgstattuple_approx for toasted table
Date: 2019-03-03 15:59:56
Message-ID: CA+t6e1kTYbcQY4ohOS-OUvyu5T+=PTj_TZKvyMBeCS5V6V7ZFA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,
I was testing pgstattuple and I realized that pgstattuple is working on
toasted table but pgstattuple_approx is raising the next error msg :

ERROR: "pg_toast_18292" is not a table or materialized view

ahm, is that because the pgstattuple_approx uses visibility map ? Can
someone explain ? tnx.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Laurenz Albe 2019-03-04 05:21:39 Re: pgstattuple_approx for toasted table
Previous Message ROS Didier 2019-03-02 19:19:15 RE: How to get the content of Bind variables