explain.depesz.com

PostgreSQL's explain analyze made readable

Result: p69e

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.006 ↑ 1.0 1 1

Aggregate (cost=793.16..793.17 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=1)

2. 0.000 0.003 ↓ 0.0 0 1

Nested Loop (cost=1.12..793.15 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Join Filter: (issues.description ~~ (('%'::text || (grafana_integrations.grafana_url)::text) || '%'::text))
3. 0.003 0.003 ↓ 0.0 0 1

Nested Loop (cost=0.56..87.94 rows=25 width=528) (actual time=0.003..0.003 rows=0 loops=1)

  • -> Index Scan using grafana_integrations_project_id_idx on grafana_integrations (cost=0.12..22.38 rows=25 width=524) (actual time=0.002..0.00
4. 0.000 0.000 ↓ 0.0 0

Index Only Scan using projects_pkey on projects (cost=0.43..2.61 rows=1 width=4) (never executed)

  • Index Cond: (id = grafana_integrations.project_id)
  • Heap Fetches: 0
5. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_issues_on_project_id_and_rel_position_and_state_id_and_id on issues (cost=0.56..26.21 rows=114 width=267) (never executed)

  • Index Cond: (project_id = projects.id)
Planning time : 1.543 ms
Execution time : 0.084 ms