Re: Taking lot time

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 appreactiated !

On Thu, Nov 26, 2015 at 12:04 AM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> 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 rows.
> Which is correct 20 rows or columns and if columns how many rows?
>
> FROM detail i,
>> adjdetail ia,
>> WHERE i.trans_id = ia.detail_id AND
>> (i.event = ANY (ARRAY[21, 22, 3, 5]))
>> created indexes on where clause declared columns.
>>
>> Taking a lot of time above ..?any help apprectiated !.
>>
>
> A lot of time being?
>
> Where are you measuring this time?
> Remember populating a GUI with lots of data can take time.
>
>
>> I have total 4 gb ram,i changed below in postgres.conf
>>
>> shared_buffers--1024mb
>> temp_bufffers=8mb
>> work_mem=200mb
>> maintanace_work_mem=500mb
>> seq_page_cost = 1.0
>> random_page_cost = 5.0
>> effective_cache_size = 1024MB
>>
>>
>>
>> On Wed, Nov 18, 2015 at 11:12 PM, Adrian Klaver
>> <adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>> wrote:
>>
>> 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:27 AM, Adrian Klaver
>> <adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>> <mailto:adrian(dot)klaver(at)aklaver(dot)com
>> <mailto:adrian(dot)klaver(at)aklaver(dot)com>>> 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 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
>> ('{21,22,3,5}'::integer[]))"
>> " -> Hash (cost=20590.78..20590.78 rows=610978
>> width=331)"
>> " -> Seq Scan on inv_adj iad
>> (cost=0.00..20590.78
>> rows=610978
>> width=331)"
>>
>> Can you Please let me know wt happen in query..?wt
>> should i do..
>>
>>
>> And the query is?
>>
>>
>> --
>> Adrian Klaver
>> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>> <mailto:adrian(dot)klaver(at)aklaver(dot)com
>> <mailto:adrian(dot)klaver(at)aklaver(dot)com>>
>>
>>
>>
>>
>> --
>> Adrian Klaver
>> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>>
>>
>>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>