explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gELn

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

Nested Loop (cost=3.60..6.64 rows=1 width=48) (actual time=0.035..0.037 rows=1 loops=1)

  • Planning time: 0.193 ms
  • Execution time: 0.078 ms
2. 0.002 0.029 ↑ 1.0 1 1

Unique (cost=3.32..3.33 rows=1 width=24) (actual time=0.028..0.029 rows=1 loops=1)

3. 0.006 0.027 ↑ 1.0 1 1

Sort (cost=3.32..3.33 rows=1 width=24) (actual time=0.027..0.027 rows=1 loops=1)

  • Sort Key: (first_value(category_definitions_1.category_definition_id) OVER (?))
  • Sort Method: quicksort Memory: 25kB
4. 0.005 0.021 ↑ 1.0 1 1

WindowAgg (cost=0.28..3.31 rows=1 width=24) (actual time=0.019..0.021 rows=1 loops=1)

5. 0.016 0.016 ↑ 1.0 1 1

Index Scan Backward using category_definition_request_category_activation_index on category_definitions category_definitions_1 (cost=0.28..3.29 rows=1 width=24) (actual time=0.014..0.016 rows=1 loops=1)

  • Index Cond: ((request_category_id = '114393707196743940'::bigint) AND (activation_time IS NOT NULL))
6. 0.005 0.005 ↑ 1.0 1 1

Index Scan using category_definitions_pkey on category_definitions (cost=0.28..3.29 rows=1 width=48) (actual time=0.004..0.005 rows=1 loops=1)

  • Index Cond: (category_definition_id = (first_value(category_definitions_1.category_definition_id) OVER (?)))