Re: Index scan never executed? - Mailing list pgsql-sql

From Chad Thompson
Subject Re: Index scan never executed?
Date
Msg-id 00cd01c326dd$d4342180$32021aac@chad
Whole thread Raw
In response to Index scan never executed?  ("Chad Thompson" <chad@weblinkservices.com>)
List pgsql-sql
>
> I guess it's a little unclear what to print for the first number when no
> rows are output at all.  The code evidently is using the total time spent
> in the plan node, but I think it would be at least as justifiable to
> print a zero instead.  Would you have found that less confusing?  Anyone
> else have an opinion about whether to change that detail?
>

No, that makes perfect sense now that it has been explained.

> Perhaps an index on project_id would be more helpful, or a two-column
> index on (project_id, start_time).

As usual, you are in fine form.  A two-column index brought the query from
115 sec to 6.

Thanks!
Chad



pgsql-sql by date:

Previous
From: "Katka a Daniel Dunajsky"
Date:
Subject: Calculating with the time
Next
From: Raj Mathur
Date:
Subject: Dynamic views/permissions