explain.depesz.com

PostgreSQL's explain analyze made readable

Result: f1Xb

Settings
# exclusive inclusive rows x rows loops node
1. 0.094 585.987 ↑ 1.0 1 1

Aggregate (cost=87.56..87.57 rows=1 width=8) (actual time=585.987..585.987 rows=1 loops=1)

2. 483.770 585.893 ↓ 123.0 123 1

Nested Loop (cost=0.87..87.56 rows=1 width=0) (actual time=17.199..585.893 rows=123 loops=1)

  • Join Filter: (issues.description ~~ (('%'::text || (grafana_integrations.grafana_url)::text) || '%'::text))
  • Rows Removed by Join Filter: 3463
3. 0.042 1.737 ↓ 1.8 22 1

Nested Loop (cost=0.43..29.28 rows=12 width=528) (actual time=0.232..1.737 rows=22 loops=1)

4. 0.089 0.089 ↓ 1.8 22 1

Seq Scan on grafana_integrations (cost=0.00..4.23 rows=12 width=524) (actual time=0.057..0.089 rows=22 loops=1)

  • Filter: enabled
  • Rows Removed by Filter: 2
5. 1.606 1.606 ↑ 1.0 1 22

Index Only Scan using projects_pkey on projects (cost=0.43..2.08 rows=1 width=4) (actual time=0.072..0.073 rows=1 loops=22)

  • Index Cond: (id = grafana_integrations.project_id)
  • Heap Fetches: 7
6. 100.386 100.386 ↓ 1.4 163 22

Index Scan using index_issues_on_project_id_and_iid on issues (cost=0.44..2.77 rows=119 width=268) (actual time=0.572..4.563 rows=163 loops=22)

  • Index Cond: (project_id = projects.id)
Planning time : 11.255 ms
Execution time : 586.087 ms