Hi there,,
How can use explain to estimate workload contains more than one query in the
same time.
such as
explain (q1,q2,q3)..i want the total cost for all queries in the workload
using one explain ,,??
regards..
thank's Kevin
how i can read query runtime if i want to run query from java ?
regards,,,
From: Kevin Grittner
To: pgsql-performance group ; Radhya sahal
Sent: Tuesday, October 11, 2011 12:15 PM
Subject: Re: [PERFORM] postgresql query runtime
Radhya
Hi
I want to know how can i measure runtime query in postgresql if i use command
line psql?
not explain rutime for the query such as the runtime which appear in pgadmin ?
such as Total query runtime: 203 ms.
- Forwarded Message
From: Radhya sahal
To: Samuel Gendler
Sent: Sun, July 10, 2011 11:25:46 AM
Subject: Re: [PERFORM] query total time im milliseconds
Thank's
long startTime = System.currentTimeMillis();
//execute query
long executionTime = System.currentTimeMillis() - star
Dear all ,
could any one help me?
when i use pgadmin to exceute a query it shows the total time for query ..
such as
(select * form table_name.)query total time is for example 100 ms
i want to know the command that can retetive the query total time
in millisecond
if i connect with p
Dear all ,
could any one help me?
when i use pgadmin to exceute a query it shows the total time for query ..
such as
(select * form table_name.)query total time is for example 100 ms
i want to know the command that can retetive the query total time
in millisecond
if i connect with po
Dear all ,
could any one help me?
when i use pgadmin to exceute a query it shows the total time for query ..
such as
(select * form table_name.)query total time is for example 100 ms
i want to know the command that can retetive the query total time
in millisecond
if i connect with po
Dear all ,
could any one help me?
when i use pgadmin to exceute a query it shows the total time for query ..
such as
(select * form table_name.)query total time is for example 100 ms
i want to know the command that can retentive the query total time
in millisecond
if i connect with post
Dear all,
How can retrieve total query run-time when i run any query with out using
explain
for example when i run any query such as
select * from tablel1;
Total query runtime: 443 ms.
i want a function can return "runtime: 443 ms" with out using explain
i want this command to call it from
..
From: Nathan Boley
To: Radhya sahal
Cc: pgsql-performance group
Sent: Mon, April 11, 2011 4:09:07 PM
Subject: Re: [PERFORM] how explain works
> how explian works as math equations to estimate cost with constatn query
> parameters
> such as cpu_tuple cost ,random page co
Dear ,all
plz could any one help me !!!
how explian works as math equations to estimate cost with constatn query
parameters
such as cpu_tuple cost ,random page cost ...etc
i want maths expression in order to know how these parameters will effect in
cost ???
please any one can help me ??
R
Dear ,all
i would to ask you about how postgresql optimizer parameters :-
1- random page cost
2- cpu tuple cost3- cpu operator cost4- cpu index tuple cost5- effective cache
size
play as parameters in cost estimator equation
i imagine that cost function is the same as
f(x,y,z,)=ax+by..
c
Database Test Suite
H o w are you all ??
I am new in this group.
I have windows 7 as OS and i installed postgresql 9.0 i want
a to do some tests so i need bench mark to test some workloads?
i need the same as Database Test Suite
http://sourceforge.net/projects/osdldbt/
but for windows can any one
13 matches
Mail list logo
