explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ims

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

Nested Loop (cost=74.40..21,633.25 rows=6 width=498) (actual time=228.770..228.770 rows=0 loops=1)

2. 0.013 228.767 ↓ 0.0 0 1

Bitmap Heap Scan on order_products (cost=73.96..6,880.06 rows=1,748 width=4) (actual time=228.767..228.767 rows=0 loops=1)

  • Recheck Cond: ((title)::text ~~* '%my best products%'::text)
3. 228.754 228.754 ↓ 0.0 0 1

Bitmap Index Scan on order_products_title_pg_trgm (cost=0.00..73.53 rows=1,748 width=0) (actual time=228.754..228.754 rows=0 loops=1)

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

Index Scan using index_orders_on_id_and_store_id on orders (cost=0.43..8.43 rows=1 width=498) (never executed)

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