explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tDdo

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 1.205 ↓ 0.0 0 1

Limit (cost=1,863.85..1,864.56 rows=284 width=53) (actual time=1.204..1.205 rows=0 loops=1)

2. 0.030 1.202 ↓ 0.0 0 1

Sort (cost=1,863.85..1,864.56 rows=284 width=53) (actual time=1.201..1.202 rows=0 loops=1)

  • Sort Key: ((((ts_rank(items_0.full_text_v2, '''water'''::tsquery, 1) * '100'::double precision) + (COALESCE(products_conversions.score, '0'::double precision) * '1000'::double precision)) * '1'::double precision)) DESC, items_0.item_id DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.003 1.172 ↓ 0.0 0 1

WindowAgg (cost=31.72..1,852.28 rows=284 width=53) (actual time=1.172..1.172 rows=0 loops=1)

4. 0.001 1.169 ↓ 0.0 0 1

Nested Loop Left Join (cost=31.72..1,843.05 rows=284 width=456) (actual time=1.169..1.169 rows=0 loops=1)

5. 0.002 1.168 ↓ 0.0 0 1

Hash Left Join (cost=31.16..1,052.10 rows=284 width=452) (actual time=1.167..1.168 rows=0 loops=1)

  • Hash Cond: ((items_0.inventory_area_id = items_availabilities.inventory_area_id) AND (items_0.item_id = items_availabilities.item_id))
6. 0.003 1.166 ↓ 0.0 0 1

Bitmap Heap Scan on items_0 (cost=23.52..1,042.98 rows=284 width=448) (actual time=1.165..1.166 rows=0 loops=1)

  • Recheck Cond: ((full_text_v2 @@ '''water'''::tsquery) AND (inventory_area_id = 20,636))
  • Filter: (visible AND available)
7. 1.163 1.163 ↓ 0.0 0 1

Bitmap Index Scan on search_index_v2_items_0 (cost=0.00..23.45 rows=915 width=0) (actual time=1.162..1.163 rows=0 loops=1)

  • Index Cond: ((full_text_v2 @@ '''water'''::tsquery) AND (inventory_area_id = 20,636))
8. 0.000 0.000 ↓ 0.0 0

Hash (cost=7.53..7.53 rows=7 width=20) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on items_availabilities_0 items_availabilities (cost=1.31..7.53 rows=7 width=20) (never executed)

  • Recheck Cond: (inventory_area_id = 20,636)
10. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on items_availabilities_0_inventory_area_id_idx (cost=0.00..1.31 rows=7 width=0) (never executed)

  • Index Cond: (inventory_area_id = 20,636)
11. 0.000 0.000 ↓ 0.0 0

Index Scan using index_products_conversions_on_cpk on products_conversions (cost=0.56..2.79 rows=1 width=12) (never executed)

  • Index Cond: ((version = 1) AND (product_id = items_0.product_id) AND ((query)::text = 'water'::text))
Planning time : 14.371 ms
Execution time : 1.496 ms