explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RkBp

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 0.084 ↑ 1.0 1 1

Limit (cost=4.58..4.58 rows=1 width=407) (actual time=0.081..0.084 rows=1 loops=1)

2. 0.022 0.079 ↑ 1.0 1 1

Sort (cost=4.58..4.58 rows=1 width=407) (actual time=0.078..0.079 rows=1 loops=1)

  • Sort Key: (CASE WHEN ((routes.path)::text = 'gitlab-org'::text) THEN 0 ELSE 1 END)
  • Sort Method: quicksort Memory: 25kB
3. 0.012 0.057 ↑ 1.0 1 1

Nested Loop (cost=0.29..4.57 rows=1 width=407) (actual time=0.054..0.057 rows=1 loops=1)

4. 0.029 0.029 ↑ 1.0 1 1

Index Scan using index_on_routes_lower_path on routes (cost=0.14..2.17 rows=1 width=63) (actual time=0.026..0.029 rows=1 loops=1)

  • Index Cond: (lower((path)::text) = 'gitlab-org'::text)
  • Filter: ((source_type)::text = 'Namespace'::text)
5. 0.016 0.016 ↑ 1.0 1 1

Index Scan using namespaces_pkey on namespaces (cost=0.14..2.16 rows=1 width=340) (actual time=0.016..0.016 rows=1 loops=1)

  • Index Cond: (id = routes.source_id)
  • Filter: ((type)::text = 'Group'::text)
Planning time : 0.988 ms
Execution time : 0.290 ms