Posts tagged ‘postgres’

Postgres query plan viewer

This will draw postgres query plans (from EXPLAIN and friends) in a form which may well be easier for you to parse.

http://www.dbplanview.com/

Advertisements

September 23, 2010 at 5:30 pm Leave a comment

Postgres sql basic querying based on datetime

For the benefit of google (and me when I’m using google)

In postgres and probably most other SQLs the following

SELECT * FROM table where creation_date > timestamp 'now' - interval '2 hours';

finds all records that were created in the last 2 hours.

See also:
http://www.postgresql.org/docs/8.0/static/datatype-datetime.html

March 11, 2010 at 9:29 pm Leave a comment


December 2017
M T W T F S S
« Nov    
 123
45678910
11121314151617
18192021222324
25262728293031