explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KOwE : Without the first argument

Settings
# exclusive inclusive rows x rows loops node
1. 0.787 63.660 ↑ 1.0 1 1

Aggregate (cost=6,284.40..6,284.43 rows=1 width=20) (actual time=63.659..63.660 rows=1 loops=1)

2. 0.708 62.873 ↓ 8.2 916 1

Nested Loop Left Join (cost=3,465.82..6,266.76 rows=112 width=163) (actual time=13.267..62.873 rows=916 loops=1)

3. 0.704 61.249 ↓ 8.2 916 1

Nested Loop Left Join (cost=3,465.54..6,212.51 rows=112 width=159) (actual time=13.262..61.249 rows=916 loops=1)

4. 0.506 59.629 ↓ 8.2 916 1

Nested Loop (cost=3,465.25..5,846.13 rows=112 width=155) (actual time=13.251..59.629 rows=916 loops=1)

5. 28.575 57.291 ↓ 1.3 916 1

Hash Join (cost=3,464.97..5,614.50 rows=689 width=4) (actual time=13.233..57.291 rows=916 loops=1)

  • Hash Cond: (branch_commit.commit_id = commit.id)
6. 25.607 25.607 ↑ 1.0 113,956 1

Seq Scan on branch_commit (cost=0.00..1,849.80 rows=114,180 width=8) (actual time=0.007..25.607 rows=113,956 loops=1)

7. 0.233 3.109 ↑ 1.0 779 1

Hash (cost=3,454.89..3,454.89 rows=806 width=4) (actual time=3.109..3.109 rows=779 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 36kB
8. 2.876 2.876 ↑ 1.0 779 1

Index Only Scan using commit_id_contr_id_date_time_idx on commit (cost=0.42..3,454.89 rows=806 width=4) (actual time=1.490..2.876 rows=779 loops=1)

  • Index Cond: (contributor_id = 1,040,655,273)
  • Heap Fetches: 3
9. 1.832 1.832 ↑ 1.0 1 916

Index Scan using branch_pkey on branch b (cost=0.29..0.34 rows=1 width=155) (actual time=0.002..0.002 rows=1 loops=916)

  • Index Cond: (id = branch_commit.branch_id)
  • Filter: (organization_id = 774,527,742)
10. 0.916 0.916 ↓ 0.0 0 916

Index Scan using pull_request_pkey on pull_request p (cost=0.29..3.27 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=916)

  • Index Cond: (id = b.pull_request_id)
11. 0.916 0.916 ↑ 1.0 1 916

Index Scan using release_pkey on release r (cost=0.28..0.48 rows=1 width=12) (actual time=0.001..0.001 rows=1 loops=916)

  • Index Cond: (id = b.release_id)
Planning time : 0.838 ms
Execution time : 63.799 ms