explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BRIw : metrics issue

Settings
# exclusive inclusive rows x rows loops node
1. 2.277 787.929 ↑ 1.0 1 1

Aggregate (cost=34,296.17..34,296.21 rows=1 width=24) (actual time=787.928..787.929 rows=1 loops=1)

2. 0.616 90.112 ↓ 9.0 830 1

Nested Loop Left Join (cost=15,904.30..18,257.08 rows=92 width=163) (actual time=42.152..90.112 rows=830 loops=1)

3. 1.150 87.836 ↓ 9.0 830 1

Nested Loop Left Join (cost=15,904.01..18,212.00 rows=92 width=159) (actual time=42.144..87.836 rows=830 loops=1)

4. 1.115 85.856 ↓ 9.0 830 1

Nested Loop (cost=15,903.72..17,911.10 rows=92 width=155) (actual time=42.128..85.856 rows=830 loops=1)

5. 27.301 82.251 ↓ 1.5 830 1

Hash Join (cost=15,903.44..17,724.23 rows=552 width=4) (actual time=42.084..82.251 rows=830 loops=1)

  • Hash Cond: (branch_commit.commit_id = commit.id)
6. 23.093 23.093 ↑ 1.0 99,177 1

Seq Scan on branch_commit (cost=0.00..1,560.30 rows=99,230 width=8) (actual time=0.010..23.093 rows=99,177 loops=1)

7. 0.288 31.857 ↑ 1.0 701 1

Hash (cost=15,894.27..15,894.27 rows=733 width=4) (actual time=31.856..31.857 rows=701 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 33kB
8. 31.569 31.569 ↑ 1.0 701 1

Seq Scan on commit (cost=0.00..15,894.27 rows=733 width=4) (actual time=1.284..31.569 rows=701 loops=1)

  • Filter: (contributor_id = 1,040,655,273)
  • Rows Removed by Filter: 131,162
9. 2.490 2.490 ↑ 1.0 1 830

Index Scan using branch_pkey on branch b (cost=0.29..0.34 rows=1 width=155) (actual time=0.003..0.003 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. 1.660 1.660 ↑ 1.0 1 830

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

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

SubPlan (for Aggregate)

13. 114.024 695.540 ↓ 0.0 0 830

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

14. 140.270 140.270 ↓ 19.0 266 830

Index Only Scan using branch_commit_branch_id_commit_id_key on branch_commit bc (cost=0.42..52.66 rows=14 width=4) (actual time=0.006..0.169 rows=266 loops=830)

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

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

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

Hash Join (cost=16,483.16..18,303.95 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,560.30 rows=99,230 width=8) (never executed)

18. 0.000 0.000 ↓ 0.0 0

Hash (cost=16,483.11..16,483.11 rows=4 width=4) (never executed)

19. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.00..16,483.11 rows=4 width=4) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
20. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on commit c_1 (cost=0.00..15,482.71 rows=2 width=4) (never executed)

  • Filter: ((contributor_id = 1,040,655,273) AND (date("time") >= '2020-01-02'::date) AND (date("time") <= '2020-01-09'::date))
Planning time : 1.253 ms
Execution time : 788.216 ms