explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EbmA

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 1.006 ↓ 13.0 13 1

Nested Loop Left Join (cost=2.72..684.06 rows=1 width=5,297) (actual time=0.243..1.006 rows=13 loops=1)

2. 0.006 0.991 ↓ 13.0 13 1

Nested Loop Left Join (cost=2.29..680.60 rows=1 width=3,634) (actual time=0.241..0.991 rows=13 loops=1)

3. 0.010 0.816 ↓ 13.0 13 1

Nested Loop Left Join (cost=1.85..677.14 rows=1 width=1,971) (actual time=0.210..0.816 rows=13 loops=1)

4. 0.006 0.806 ↓ 13.0 13 1

Nested Loop Left Join (cost=1.29..673.55 rows=1 width=1,252) (actual time=0.207..0.806 rows=13 loops=1)

5. 0.020 0.657 ↓ 13.0 13 1

Nested Loop (cost=0.85..670.08 rows=1 width=476) (actual time=0.205..0.657 rows=13 loops=1)

6. 0.329 0.329 ↑ 1.0 154 1

Index Scan using vulnerability_feedback_unique_idx on vulnerability_feedback (cost=0.28..112.47 rows=155 width=176) (actual time=0.037..0.329 rows=154 loops=1)

  • Index Cond: (project_id = 278964)
7. 0.308 0.308 ↓ 0.0 0 154

Index Scan using index_ci_pipelines_on_project_id_and_id_desc on ci_pipelines (cost=0.57..3.59 rows=1 width=300) (actual time=0.002..0.002 rows=0 loops=154)

  • Index Cond: ((project_id = 278964) AND (id = vulnerability_feedback.pipeline_id))
8. 0.143 0.143 ↓ 0.0 0 13

Index Scan using issues_pkey on issues (cost=0.44..3.46 rows=1 width=776) (actual time=0.011..0.011 rows=0 loops=13)

  • Index Cond: (id = vulnerability_feedback.issue_id)
9. 0.000 0.000 ↓ 0.0 0 13

Index Scan using merge_requests_pkey on merge_requests (cost=0.56..3.58 rows=1 width=719) (actual time=0.000..0.000 rows=0 loops=13)

  • Index Cond: (id = vulnerability_feedback.merge_request_id)
10. 0.169 0.169 ↑ 1.0 1 13

Index Scan using users_pkey on users (cost=0.43..3.45 rows=1 width=1,663) (actual time=0.013..0.013 rows=1 loops=13)

  • Index Cond: (id = vulnerability_feedback.author_id)
11. 0.000 0.000 ↓ 0.0 0 13

Index Scan using users_pkey on users comment_authors_vulnerability_feedback (cost=0.43..3.45 rows=1 width=1,663) (actual time=0.000..0.000 rows=0 loops=13)

  • Index Cond: (id = vulnerability_feedback.comment_author_id)
Planning time : 2.366 ms
Execution time : 1.273 ms