explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HgBI : Optimization for: plan #kQr2

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 0.051 ↓ 0.0 0 1

Unique (cost=16.62..16.68 rows=2 width=205) (actual time=0.051..0.051 rows=0 loops=1)

2. 0.019 0.051 ↓ 0.0 0 1

Sort (cost=16.62..16.62 rows=2 width=205) (actual time=0.050..0.051 rows=0 loops=1)

  • Sort Key: s0.id, s0.identifier, s0.name, s0.description, s0.uuidv2, s0.alias, s0.status, s0.allow_frontend, s0.id, s0.organization_id, s0.created_at, s0.updated_at
  • Sort Method: quicksort Memory: 25kB
3. 0.002 0.032 ↓ 0.0 0 1

Append (cost=0.28..16.61 rows=2 width=205) (actual time=0.031..0.032 rows=0 loops=1)

4. 0.018 0.018 ↓ 0.0 0 1

Index Scan using index_scenarios_on_organization_id_and_alias on scenarios s0 (cost=0.28..8.29 rows=1 width=127) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: ((organization_id = 44) AND ((alias)::text = 'github_6'::text))
5. 0.012 0.012 ↓ 0.0 0 1

Index Scan using index_scenarios_on_organization_id_and_alias on scenarios s0_1 (cost=0.28..8.29 rows=1 width=127) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (organization_id = 44)
  • Filter: ((uuidv2)::text = 'github_6'::text)
  • Rows Removed by Filter: 2
Planning time : 0.236 ms
Execution time : 0.107 ms