>
> 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