Re: [PERFORM] Simple SQL too slow

2017-07-02 Thread Daviramos Roussenq Fortunato
REAL HARDWARE. I ran the same SQL via pgsql it took only 13 seconds. My bottleneck has everything to be network. #tcptrack -i eth1 Analyzing the traffic on the network, the speed is only 512Kb / s on port 5432. # ethtool eth1 Settings for eth1: Supported ports: [ TP ] Supported

Re: [PERFORM] Simple SQL too slow

2017-07-02 Thread Nicolas CHARLES
Le 2 juillet 2017 10:39:09 GMT+02:00, Tomas Vondra a écrit : > > >On 07/02/2017 03:26 AM, Daviramos Roussenq Fortunato wrote: >> I am using pgAdmin for SQL test. >> >> Linux: >> >> EXPLAIN ANALYZE select * from >> "Seq Scan on lancamentosteste (cost=0.00..49289.74 rows=1883774 >> width=92) (a

Re: [PERFORM] Simple SQL too slow

2017-07-02 Thread Tomas Vondra
On 07/02/2017 03:26 AM, Daviramos Roussenq Fortunato wrote: I am using pgAdmin for SQL test. Linux: EXPLAIN ANALYZE select * from "Seq Scan on lancamentosteste (cost=0.00..49289.74 rows=1883774 width=92) (actual time=0.016..1194.453 rows=1883699 loops=1)" "Total runtime: 2139.067 ms" Wind

Re: [PERFORM] Simple SQL too slow

2017-07-01 Thread Andreas Kretschmer
On 2 July 2017 02:26:01 GMT+01:00, Daviramos Roussenq Fortunato wrote: >I am using pgAdmin for SQL test. > > Are you using real hardware or is it vitual? Needs the query without explain analyse the same time? Can you try it with psql (THE command line interface)? Regards, Andreas -- 2ndQuad

Re: [PERFORM] Simple SQL too slow

2017-07-01 Thread Daviramos Roussenq Fortunato
I am using pgAdmin for SQL test. Linux: EXPLAIN ANALYZE select * from "Seq Scan on lancamentosteste (cost=0.00..49289.74 rows=1883774 width=92) (actual time=0.016..1194.453 rows=1883699 loops=1)" "Total runtime: 2139.067 ms" Windows: "Seq Scan on lancamentosteste (cost=0.00..49288.67 rows=1883

Re: [PERFORM] Simple SQL too slow

2017-07-01 Thread Julien Rouhaud
On 01/07/2017 22:58, Tomas Vondra wrote: > After that, you need to determine what is the bottleneck. Perhaps the > resources are saturated by something else running on the system - other > queries, maybe something else running next to PostgreSQL. Look at top > and iotop while running the queries, a

Re: [PERFORM] Simple SQL too slow

2017-07-01 Thread Tomas Vondra
Hello, On 07/01/2017 10:39 PM, Daviramos Roussenq Fortunato wrote: What tests could I do. Rigid Linux disk is much faster than Windows, I should get a much better perfomace on this Linux. What test battery do you recommend I do? I'm not sure what you mean by "rigid disk" or "test battery",

Re: [PERFORM] Simple SQL too slow

2017-07-01 Thread Daviramos Roussenq Fortunato
What tests could I do. Rigid Linux disk is much faster than Windows, I should get a much better perfomace on this Linux. What test battery do you recommend I do? 2017-07-01 16:44 GMT-03:00 Andreas Kretschmer : > On 1 July 2017 17:56:13 GMT+01:00, Daviramos Roussenq Fortunato < > daviramo...@gma

Re: [PERFORM] Simple SQL too slow

2017-07-01 Thread Andreas Kretschmer
On 1 July 2017 17:56:13 GMT+01:00, Daviramos Roussenq Fortunato wrote: >Debian: > >SELECT reltuples::numeric FROM pg_class WHERE oid = >'mytable'::regclass; >retuples=1883770 > --31ms > >SELECT pg_relation_filepath(oid), relpages FROM pg_class WHERE relname >= >'mytable'; >pg_relation_filepath=ba

Re: [PERFORM] Simple SQL too slow

2017-07-01 Thread Daviramos Roussenq Fortunato
Debian: SELECT reltuples::numeric FROM pg_class WHERE oid = 'mytable'::regclass; retuples=1883770 --31ms SELECT pg_relation_filepath(oid), relpages FROM pg_class WHERE relname = 'mytable'; pg_relation_filepath=base/1003173/1204921 relpages=30452 --31ms Windows SELECT reltuples::numeric FROM p

Re: [PERFORM] Simple SQL too slow

2017-06-30 Thread Andreas Kretschmer
On 30 June 2017 20:14:33 GMT+01:00, Daviramos Roussenq Fortunato wrote: >Hi List, > >I have a Server where a simple SQL is taking a long time to return the >results the Server settings are as follows: > >Debian GNU/Linux 7 (wheezy) >CPU: Intel(R) Xeon(R) CPU E5405 @ 2.00GHz >Mem: 16GB