explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PioK

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

Nested Loop (cost=0.58..2,529.97 rows=10 width=2,047) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Limit (cost=0.44..2,480.12 rows=10 width=1,545) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

WindowAgg (cost=0.44..8,565,566.99 rows=34,543 width=1,545) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Scan using product_pkey on product (cost=0.44..8,565,135.20 rows=34,543 width=1,537) (actual rows= loops=)

  • Filter: (catalog_unique_id = '717979f4-0d1c-4897-84f7-b31ec39b392a'::uuid)
5. 0.000 0.000 ↓ 0.0

Index Scan using catalog_pkey on catalog (cost=0.15..4.96 rows=1 width=502) (actual rows= loops=)

  • Index Cond: (id = product.catalog_id)