| From: | Paul Ramsey <pramsey(at)cleverelephant(dot)ca> |
|---|---|
| To: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
| Subject: | Less is More |
| Date: | 2015-06-22 13:09:23 |
| Message-ID: | etPan.55880908.41b71efb.173ac@Crane.local |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hey all,
I have an odd performance quirk I wonder if anyone has any theories for… (not a one-time result, table all heated up, etc)
spain=# explain analyze select way from planet_osm_point; QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------
Seq Scan on planet_osm_point (cost=0.00..37240.97 rows=1748797 width=32) (actual time=0.044..813.521 rows=1748797 loops=1)
Total runtime: 902.256 ms
(2 rows)
Time: 902.690 ms
spain=# explain analyze select * from planet_osm_point;
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Seq Scan on planet_osm_point (cost=0.00..37240.97 rows=1748797 width=848) (actual time=0.051..241.413 rows=1748797 loops=1)
Total runtime: 330.271 ms
(2 rows)
Time: 331.869 ms
Thanks,
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2015-06-22 13:18:53 | Re: Less is More |
| Previous Message | Christian Ramseyer | 2015-06-22 11:51:57 | How to speed up pg_trgm / gin index scan |