Re: [GENERAL] Taking lot time

2015-11-27 Thread Albe Laurenz
It is difficult to read your e-mails. Ramesh T wrote: >> When this thread started you said you where selecting 20 rows. > > Yes. >> Which is correct 20 rows or columns and if columns how many rows? > > Yes,I did selected 20 columns from two tables. >> Where are you measuring this time? > > He

Re: [GENERAL] Taking lot time

2015-11-26 Thread Ramesh T
When this thread started you said you where selecting 20 rows. Yes. Which is correct 20 rows or columns and if columns how many rows? Yes,I did selected 20 columns from two tables. Where are you measuring this time? Here is the query plan, http://explain.depesz.com/s/EeYT Any Help appreactiate

Re: [GENERAL] Taking lot time

2015-11-25 Thread Melvin Davidson
Adrian, He never stated what the O/S is. I strongly suspect that he is using PgAdmin to connect to a remote server, which adds another degree of complication. So at the very least, we also need to know if the server is local or remote and what the O/S is. Plus, as you have requested before, exactl

Re: [GENERAL] Taking lot time

2015-11-25 Thread Adrian Klaver
On 11/25/2015 07:46 AM, Ramesh T wrote: Hi All, 9.3 version using pgadmin3 Query like below,20 columns fetching SELECT col1,col2,col3,...col.20 FROM detail i, adjdetail ia, WHE

Re: [GENERAL] Taking lot time

2015-11-25 Thread Adrian Klaver
On 11/25/2015 07:46 AM, Ramesh T wrote: First, please take a look at this: https://en.wikipedia.org/wiki/Posting_style Hi All, 9.3 version using pgadmin3 Query like below,20 columns fetching SELECT col1,col2,col3,...col.20 When this thread started you said you where selecting 20

Re: [GENERAL] Taking lot time

2015-11-25 Thread Ramesh T
Hi All, 9.3 version using pgadmin3 Query like below,20 columns fetching SELECT col1,col2,col3,...col.20 FROM detail i, adjdetail ia, WHERE i.trans_id = ia.detail_id AND (i.event = ANY

Re: [GENERAL] Taking lot time

2015-11-18 Thread Adrian Klaver
On 11/17/2015 04:18 AM, Ramesh T wrote: the query is big it's selecting 20 rows from two table like i mentioned above exaplain analyze what should i do..?any help Please do not top post. I must be missing a post, as I see no explanation of what the query is doing. On Wed, Nov 4, 2015 at 4:

Re: [GENERAL] Taking lot time

2015-11-18 Thread Karsten Hilbert
On Tue, Nov 17, 2015 at 05:48:36PM +0530, Ramesh T wrote: > the query is big it's selecting 20 rows from two table like i mentioned > above exaplain analyze > > what should i do..?any help Considering to post the query might be a reasonable first step. Karsten > On Wed, Nov 4, 2015 at 4:27 AM,

Re: [GENERAL] Taking lot time

2015-11-18 Thread Melvin Davidson
And as always, what is the O/S and the version of PostgreSQL?? On Tue, Nov 17, 2015 at 7:18 AM, Ramesh T wrote: > the query is big it's selecting 20 rows from two table like i mentioned > above exaplain analyze > > what should i do..?any help > > On Wed, Nov 4, 2015 at 4:27 AM, A

Re: [GENERAL] Taking lot time

2015-11-18 Thread Ramesh T
the query is big it's selecting 20 rows from two table like i mentioned above exaplain analyze what should i do..?any help On Wed, Nov 4, 2015 at 4:27 AM, Adrian Klaver wrote: > On 11/03/2015 06:42 AM, Ramesh T wrote: > >> I have a Query it taking a lot of time to fetch results >> so,explain qu

Re: [GENERAL] Taking lot time

2015-11-03 Thread John R Pierce
On 11/3/2015 6:42 AM, Ramesh T wrote: I have a Query it taking a lot of time to fetch results so,explain query gave "Hash Join (cost=55078.00..202405.95 rows=728275 width=418)" " Hash Cond: (itd.tran_id = iad._adj__id)" " -> Seq Scan on inv_detail itd (cost=0.00..40784.18 rows=731029 width

Re: [GENERAL] Taking lot time

2015-11-03 Thread Melvin Davidson
And in addition to providing the actual query, the structure (and indexes) of all tables involved) are needed. On Tue, Nov 3, 2015 at 5:59 PM, Rob Sargent wrote: > On 11/03/2015 07:42 AM, Ramesh T wrote: > > I have a Query it taking a lot of time to fetch results > so,explain query gave > > "Has

Re: [GENERAL] Taking lot time

2015-11-03 Thread Rob Sargent
On 11/03/2015 07:42 AM, Ramesh T wrote: I have a Query it taking a lot of time to fetch results so,explain query gave "Hash Join (cost=55078.00..202405.95 rows=728275 width=418)" " Hash Cond: (itd.tran_id = iad._adj__id)" " -> Seq Scan on inv_detail itd (cost=0.00..40784.18 rows=731029 wid

Re: [GENERAL] Taking lot time

2015-11-03 Thread Adrian Klaver
On 11/03/2015 06:42 AM, Ramesh T wrote: I have a Query it taking a lot of time to fetch results so,explain query gave "Hash Join (cost=55078.00..202405.95 rows=728275 width=418)" " Hash Cond: (itd.tran_id = iad._adj__id)" " -> Seq Scan on inv_detail itd (cost=0.00..40784.18 rows=731029 widt

[GENERAL] Taking lot time

2015-11-03 Thread Ramesh T
I have a Query it taking a lot of time to fetch results so,explain query gave "Hash Join (cost=55078.00..202405.95 rows=728275 width=418)" " Hash Cond: (itd.tran_id = iad._adj__id)" " -> Seq Scan on inv_detail itd (cost=0.00..40784.18 rows=731029 width=95)" "Filter: (event_type = ANY