explain.depesz.com

PostgreSQL's explain analyze made readable

Result: s9Rr : Commit Count -- FIS DB02

Settings
# exclusive inclusive rows x rows loops node
1. 6.108 802.014 ↑ 1.0 1 1

Aggregate (cost=3,767,073.00..3,767,073.01 rows=1 width=8) (actual time=802.013..802.014 rows=1 loops=1)

2. 6.827 795.906 ↑ 2.7 12,332 1

Nested Loop (cost=2.58..3,766,990.72 rows=32,912 width=8) (actual time=14.128..795.906 rows=12,332 loops=1)

3. 1.192 358.454 ↓ 1.2 3,445 1

Nested Loop (cost=1.87..111,910.05 rows=2,785 width=8) (actual time=8.237..358.454 rows=3,445 loops=1)

4. 0.013 5.287 ↑ 18.0 1 1

Nested Loop (cost=1.29..82.59 rows=18 width=12) (actual time=5.264..5.287 rows=1 loops=1)

5. 0.011 3.703 ↑ 18.0 1 1

Nested Loop (cost=0.86..60.47 rows=18 width=8) (actual time=3.688..3.703 rows=1 loops=1)

6. 2.391 2.391 ↑ 18.0 1 1

Index Scan using index_analysis_sloc_sets_on_analysis_id_sloc_set_id on analysis_sloc_sets ass (cost=0.43..16.41 rows=18 width=8) (actual time=2.381..2.391 rows=1 loops=1)

  • Index Cond: (analysis_id = 39,993,914)
  • Filter: (as_of IS NOT NULL)
7. 1.301 1.301 ↑ 1.0 1 1

Index Scan using sloc_sets_pkey on sloc_sets ss (cost=0.43..2.45 rows=1 width=8) (actual time=1.301..1.301 rows=1 loops=1)

  • Index Cond: (id = ass.sloc_set_id)
8. 1.571 1.571 ↑ 1.0 1 1

Index Only Scan using code_sets_pkey on code_sets cs (cost=0.43..1.23 rows=1 width=4) (actual time=1.571..1.571 rows=1 loops=1)

  • Index Cond: (id = ss.code_set_id)
  • Heap Fetches: 0
9. 351.975 351.975 ↑ 2.2 3,445 1

Index Scan using index_on_commits_code_set_id_position on commits c (cost=0.57..6,137.59 rows=7,505 width=16) (actual time=2.969..351.975 rows=3,445 loops=1)

  • Index Cond: ((code_set_id = cs.id) AND ("position" <= ass.as_of))
  • Filter: (("time" >= '1971-01-01 00:00:00'::timestamp without time zone) AND ("time" < timezone('utc'::text, now())))
10. 430.625 430.625 ↑ 10,433.2 4 3,445

Index Only Scan using unique_diffs_on_commit_id_fyle_id on diffs d (cost=0.71..895.09 rows=41,733 width=16) (actual time=0.121..0.125 rows=4 loops=3,445)

  • Index Cond: (commit_id = c.id)
  • Heap Fetches: 4
Planning time : 11.170 ms
Execution time : 802.189 ms