Postgres Pro
Downloads
Home   >   mailing lists

Re: How to get explain plan to prefer Hash Join - Mailing list pgsql-performance

From Jeff Janes
Subject Re: How to get explain plan to prefer Hash Join
Date
Msg-id CAMkU=1zYXqn6fgcsmpDK9CT_pH=cRAZTjQChNTA_+JFxzcwHjA@mail.gmail.com
Whole thread Raw
In response to Re: How to get explain plan to prefer Hash Join  (atxcanadian <matthew.boyda@gmail.com>)
Responses Re: How to get explain plan to prefer Hash Join
List pgsql-performance
Tree view
On Thu, Mar 12, 2015 at 8:59 AM, atxcanadian <matthew.boyda@gmail.com> wrote:
Here is the output:

<http://postgresql.nabble.com/file/n5841610/pg_stat_user_table.jpg>

This is after I've manually ran analyze.

The "last_*" columns are only showing times, and not full timestamps.  Does your reporting tool drop the date part of a timestamp when it is equal to today?  Or does it just drop the date part altogether regardless of what it is?

Cheers,

Jeff 

pgsql-performance by date:

Previous
From: atxcanadian
Date:
Subject: Re: How to get explain plan to prefer Hash Join
Next
From: atxcanadian
Date:
Subject: Re: How to get explain plan to prefer Hash Join