fardeen memon <frank69in@xxxxxxxxx> writes: > here is the output of the explain query after changing the tra_date column to timestamp. If you want intelligent commentary, please (a) post EXPLAIN ANALYZE not EXPLAIN output, and (b) don't mangle the indentation. This is just about unreadable :-( regards, tom lane