|
-
Feb 2nd, 2004, 04:31 PM
#1
Thread Starter
Frenzied Member
[postgres] How to see how long a statement took
psql dbname
dbname=# EXPLAIN ANALYZE SELECT image_group,imageid, extention, description, username,TO_CHAR(date,'MM/DD/YYYY') as date FROM images WHERE image_group='3382';
Seq Scan on images (cost=0.00..2366.78 rows=510 width=108) (actual time=103.25..1041.29 rows=1 loops=1)
Total runtime: 1041.35 msec
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|