| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | Horacio Miranda <hmiranda(at)gmail(dot)com> |
| Cc: | "Carlos T(dot) Groero Carmona" <ctonetg(at)gmail(dot)com>, Lista PostgreSql <pgsql-es-ayuda(at)postgresql(dot)org> |
| Subject: | Re: Indexes parciales |
| Date: | 2019-09-03 15:43:34 |
| Message-ID: | 20190903154334.GA14428@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda |
Horacio Miranda escribió:
> On 3/09/2019 7:24 AM, Carlos T. Groero Carmona wrote:
> > Este es el resultado del explain analyze:
> > Seq Scan on mobile_users (cost=0.00..38533.34 rows=356403 width=9015)
> > (actual time=0.022..292.568 rows=356409 loops=1)
> > Filter: (org_id = 1)
> > Rows Removed by Filter: 18
> > Planning time: 2.292 ms
> > Execution time: 304.003 ms
> PS: Ese punto me confunde... son 304 ms o son 304 segundos ?
304 ms. Un tercio de segundo. A eso se le llama en Chile "quejarse de
lleno".
Saludos
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Eduardo Arenas | 2019-09-03 15:47:55 | Re: Indexes parciales |
| Previous Message | Alvaro Herrera | 2019-09-03 15:42:13 | Re: Indexes parciales |