pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Luís Roberto Weck <luisroberto@siscobra.com.br>
To: Igor Neyman <ineyman@perceptron.com>
Cc: Michael Lewis <mlewis@entrata.com>
Cc: pgsql-performance@lists.postgresql.org <pgsql-performance@lists.postgresql.org>
Subject: Re: Slow query on a one-tuple table
Date: Thu, 19 Sep 2019 17:24:39 -0300
Message-ID: <18ae8108-acaf-e9cc-96a9-ab20f4147f5a@siscobra.com.br> (raw)
In-Reply-To: <BN6PR1701MB1890A207FBF02BBC5E3C9F01DA890@BN6PR1701MB1890.namprd17.prod.outlook.com>
References: <CA+t6e1kacbVHq69aihEVeBzH_nMY5eK7bZ-UXL_FuUquEgF_gg@mail.gmail.com>
	<24571.1568910502@sss.pgh.pa.us>
	<774d6080-d6d7-e9e7-7351-9a412c7d5956@siscobra.com.br>
	<CAHOFxGqMpUxn54jMLoU4-HcUata2yfLgjEbRHdJG3k0BBDPbog@mail.gmail.com>
	<ab6ea98e-6266-7665-40b7-151c5736c08d@siscobra.com.br>
	<BN6PR1701MB1890E31E15D486A85FEC8510DA890@BN6PR1701MB1890.namprd17.prod.outlook.com>
	<bf03aedc-9201-f7c9-ef25-e795d4e1626a@siscobra.com.br>
	<BN6PR1701MB1890A207FBF02BBC5E3C9F01DA890@BN6PR1701MB1890.namprd17.prod.outlook.com>

Em 19/09/2019 17:11, Igor Neyman escreveu:
> With LIMIT 1, I get 3 shared buffers hit, pretty much always.
>
> ____________________________________________________________________________________
>
> Check if assessoria_pkey index is bloated.
>
> Regards,
> Igor Neyman
>
>

With this query[1] it shows:

current_database|schemaname|tblname   |idxname 
|real_size|extra_size|extra_ratio|fillfactor|bloat_size|bloat_ratio|is_na|
----------------|----------|----------|---------------|---------|----------|-----------|----------|----------|-----------|-----|
database_name   |public    |assessoria|assessoria_pkey| 16384|         
0|        0.0|        90|       0.0| 0.0|false|

[1]https://github.com/ioguix/pgsql-bloat-estimation/blob/master/btree/btree_bloat-superuser.sql 






view thread (13+ messages)  latest in thread

Message-ID: <18ae8108-acaf-e9cc-96a9-ab20f4147f5a@siscobra.com.br>
Permalink:  ../18ae8108-acaf-e9cc-96a9-ab20f4147f5a@siscobra.com.br/
Also on:    postgresql.org/message-id/18ae8108-acaf-e9cc-96a9-ab20f4147f5a@siscobra.com.br

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: luisroberto@siscobra.com.br, ineyman@perceptron.com, mlewis@entrata.com, pgsql-performance@lists.postgresql.org
  Subject: Re: Slow query on a one-tuple table
  In-Reply-To: <18ae8108-acaf-e9cc-96a9-ab20f4147f5a@siscobra.com.br>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox