Re: How to get explain plan to prefer Hash Join

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: atxcanadian <matthew(dot)boyda(at)gmail(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: How to get explain plan to prefer Hash Join
Date: 2015-03-12 16:25:12
Message-ID: CAMkU=1zYXqn6fgcsmpDK9CT_pH=cRAZTjQChNTA_+JFxzcwHjA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Mar 12, 2015 at 8:59 AM, atxcanadian <matthew(dot)boyda(at)gmail(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message atxcanadian 2015-03-12 17:58:08 Re: How to get explain plan to prefer Hash Join
Previous Message atxcanadian 2015-03-12 15:59:34 Re: How to get explain plan to prefer Hash Join