}
sub steps :Local Args(0) {
    my ($self, $c) = @_;
    $c->stash->{template} = 'steps.tt';
    my $page = int($c->req->param('page') || "1") || 1;
    my $resultsPerPage = 20;
    $c->stash->{page} = $page;
    $c->stash->{resultsPerPage} = $resultsPerPage;
    $c->stash->{steps} = [ $c->model('DB::BuildSteps')->search(
        { starttime => { '!=', undef },
          stoptime => { '!=', undef }
        },
        { order_by => [ "stoptime desc" ],
          rows => $resultsPerPage,
          offset => ($page - 1) * $resultsPerPage
        }) ];
    $c->stash->{total} = approxTableSize($c, "IndexBuildStepsOnStopTime");

}

}

    approxTableSize

}
sub approxTableSize {
    my ($c, $name) = @_;
    return $c->model('DB')->schema->storage->dbh->selectrow_hashref(
        "select reltuples::int from pg_class where relname = lower(?)", { }, $name)->{"reltuples"};

            <td>[% step.machine.split('@').1 || step.machine %]</td>

            <td>[% INCLUDE renderMachineName machine=step.machine %]</td>

BLOCK renderMachineName;
machine ? stripSSHUser(machine).match('^([^\.]*)').0 : "localhost";
END;

[% WRAPPER layout.tt title="Latest steps" %]
[% PROCESS common.tt %]
<p>Showing steps [% (page - 1) * resultsPerPage + 1 %] - [% (page - 1)
* resultsPerPage + steps.size %] of about [% total %] in
order of descending finish time.</p>
<table class="table table-striped table-condensed clickable-rows">
  <thead>
    <tr>
      <th></th>
      <th>What</th>
      <th>Job</th>
      <th>Build</th>
      <th>Step</th>
      <th>When</th>
      <th>Duration</th>
      <th>Machine</th>
    </tr>
  </thead>
  <tbody>
    [% FOREACH step IN steps %]
    <tr>
        <td>[% INCLUDE renderBuildStatusIcon buildstatus=step.status size=16 %]</td>
        <td><tt>[% step.drvpath.match('-(.*).drv').0 %]</tt></td>
        <td><tt>[% INCLUDE renderFullJobNameOfBuild build=step.build %]</tt></td>
        <td><a href="[% c.uri_for('/build' step.build.id) %]">[% step.build.id %]</a></td>
        <td><a class="row-link" href="[% c.uri_for('/build' step.build.id 'nixlog' step.stepnr 'tail-reload') %]">[% step.stepnr %]</a></td>
        <td>[% INCLUDE renderRelativeDate timestamp=step.stoptime %]</td>
        <td style="width: 10em">[% INCLUDE renderDuration duration = step.stoptime - step.starttime %] </td>
        <td><tt>[% INCLUDE renderMachineName machine=step.machine %]</tt></td>
      </tr>
    [% END %]
  </tbody>
</table>
[% INCLUDE renderPager %]
[% END %]

    [% INCLUDE menuItem
       uri = c.uri_for(c.controller('Root').action_for('steps'))
       title = "Latest steps" %]

create index IndexBuildStepsOnStopTime on BuildSteps(stopTime desc) where startTime is not null and stopTime is not null;

create index IndexBuildStepsOnStopTime on BuildSteps(stopTime desc) where startTime is not null and stopTime is not null;