explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ugjv

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 277,082.586 ↓ 0.0 0 1

Nested Loop (cost=0.98..10,189.38 rows=4 width=472) (actual time=277,082.586..277,082.586 rows=0 loops=1)

2. 277,082.585 277,082.585 ↓ 0.0 0 1

Index Scan using order_products_title_pg_trgm on order_products (cost=0.42..3,161.25 rows=1,533 width=4) (actual time=277,082.585..277,082.585 rows=0 loops=1)

  • Index Cond: ((title)::text ~~* '%my best products%'::text)
3. 0.000 0.000 ↓ 0.0 0

Index Scan using index_orders_on_id_and_store_id on orders (cost=0.56..4.57 rows=1 width=472) (never executed)

  • Index Cond: ((id = order_products.order_id) AND (store_id = 3605))