explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8LN9

Settings
# exclusive inclusive rows x rows loops node
1. 254.337 44,167.359 ↑ 2.8 6,199 1

Subquery Scan on ordered_commits (cost=925,150.93..1,054,277.19 rows=17,217 width=105) (actual time=39,167.322..44,167.359 rows=6,199 loops=1)

  • Filter: (ordered_commits.r = 1)
  • Rows Removed by Filter: 3420996
2. 1,746.321 43,913.022 ↑ 1.0 3,427,195 1

WindowAgg (cost=925,150.93..1,011,235.11 rows=3,443,367 width=113) (actual time=39,167.318..43,913.022 rows=3,427,195 loops=1)

3. 40,855.509 42,166.701 ↑ 1.0 3,427,195 1

Sort (cost=925,150.93..933,759.35 rows=3,443,367 width=105) (actual time=39,167.293..42,166.701 rows=3,427,195 loops=1)

  • Sort Key: b.tenant, b.repo_id, b.branch_name, b.authored_date DESC
  • Sort Method: external merge Disk: 394880kB
4. 1,311.192 1,311.192 ↑ 1.0 3,427,195 1

Seq Scan on git_commit_branch b (cost=0.00..151,118.67 rows=3,443,367 width=105) (actual time=0.021..1,311.192 rows=3,427,195 loops=1)

Planning time : 0.138 ms
Execution time : 44,249.714 ms