explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tccp

Settings
# exclusive inclusive rows x rows loops node
1. 1.701 522.915 ↑ 1.0 1 1

Aggregate (cost=17,893.41..17,893.45 rows=1 width=24) (actual time=522.915..522.915 rows=1 loops=1)

2. 0.996 57.244 ↓ 8.8 830 1

Nested Loop Left Join (cost=3,663.18..6,023.79 rows=94 width=163) (actual time=13.120..57.244 rows=830 loops=1)

3. 0.834 55.418 ↓ 8.8 830 1

Nested Loop Left Join (cost=3,662.90..5,977.73 rows=94 width=159) (actual time=13.115..55.418 rows=830 loops=1)

4. 1.106 53.754 ↓ 8.8 830 1

Nested Loop (cost=3,662.61..5,670.29 rows=94 width=155) (actual time=13.103..53.754 rows=830 loops=1)

5. 26.566 50.988 ↓ 1.5 830 1

Hash Join (cost=3,662.32..5,479.30 rows=564 width=4) (actual time=13.085..50.988 rows=830 loops=1)

  • Hash Cond: (branch_commit.commit_id = commit.id)
6. 21.446 21.446 ↑ 1.0 98,928 1

Seq Scan on branch_commit (cost=0.00..1,557.28 rows=98,928 width=8) (actual time=0.008..21.446 rows=98,928 loops=1)

7. 0.238 2.976 ↑ 1.1 701 1

Hash (cost=3,652.92..3,652.92 rows=752 width=4) (actual time=2.976..2.976 rows=701 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 33kB
8. 2.738 2.738 ↑ 1.1 701 1

Index Only Scan using commit_id_contr_id_date_time_idx on commit (cost=0.42..3,652.92 rows=752 width=4) (actual time=1.500..2.738 rows=701 loops=1)

  • Index Cond: (contributor_id = 1,040,655,273)
  • Heap Fetches: 231
9. 1.660 1.660 ↑ 1.0 1 830

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=830)

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

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=830)

  • Index Cond: (id = b.pull_request_id)
11. 0.830 0.830 ↑ 1.0 1 830

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

  • Index Cond: (id = b.release_id)
12.          

SubPlan (for Aggregate)

13. 181.097 463.970 ↓ 0.0 0 830

Nested Loop (cost=0.84..126.10 rows=1 width=0) (actual time=0.559..0.559 rows=0 loops=830)

14. 62.250 62.250 ↓ 19.0 266 830

Index Only Scan using branch_commit_branch_id_commit_id_key on branch_commit bc (cost=0.42..4.66 rows=14 width=4) (actual time=0.005..0.075 rows=266 loops=830)

  • Index Cond: (branch_id = b.id)
  • Heap Fetches: 0
15. 220.623 220.623 ↓ 0.0 0 220,623

Index Scan using commit_id_contr_id_date_time_idx on commit c (cost=0.42..8.45 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=220,623)

  • Index Cond: ((id = bc.commit_id) AND (contributor_id = 1,040,655,273) AND (date("time") >= '2020-01-02'::date) AND (date("time") <= '2020-01-09'::date))
16. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=3,704.76..5,521.74 rows=3 width=4) (never executed)

  • Hash Cond: (bc_1.commit_id = c_1.id)
17. 0.000 0.000 ↓ 0.0 0

Seq Scan on branch_commit bc_1 (cost=0.00..1,557.28 rows=98,928 width=8) (never executed)

18. 0.000 0.000 ↓ 0.0 0

Hash (cost=3,704.71..3,704.71 rows=4 width=4) (never executed)

19. 0.000 0.000 ↓ 0.0 0

Index Scan using commit_id_contr_id_date_time_idx on commit c_1 (cost=0.42..3,704.71 rows=4 width=4) (never executed)

  • Index Cond: ((contributor_id = 1,040,655,273) AND (date("time") >= '2020-01-02'::date) AND (date("time") <= '2020-01-09'::date))
Planning time : 1.476 ms
Execution time : 523.118 ms