explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vi8i

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.111 ↑ 1.0 1 1

Limit (cost=2.56..57.30 rows=1 width=26) (actual time=0.110..0.111 rows=1 loops=1)

2. 0.001 0.109 ↑ 186.0 1 1

Nested Loop (cost=2.56..10,184.77 rows=186 width=26) (actual time=0.108..0.109 rows=1 loops=1)

3. 0.003 0.094 ↑ 45.0 1 1

Nested Loop (cost=2.13..9,942.90 rows=45 width=20) (actual time=0.094..0.094 rows=1 loops=1)

4. 0.000 0.070 ↑ 2.0 1 1

Nested Loop (cost=1.56..9,899.05 rows=2 width=16) (actual time=0.070..0.070 rows=1 loops=1)

5. 0.003 0.053 ↑ 2.0 1 1

Nested Loop (cost=1.13..9,894.24 rows=2 width=12) (actual time=0.052..0.053 rows=1 loops=1)

6. 0.030 0.030 ↑ 1.0 1 1

Index Scan Backward using index_orders_on_store_id_and_source_created_at on orders (cost=0.56..9,729.34 rows=1 width=12) (actual time=0.030..0.030 rows=1 loops=1)

  • Index Cond: (store_id = 1,097)
  • Filter: ((subscriber_uid)::text = '6945774483'::text)
  • Rows Removed by Filter: 1
7. 0.020 0.020 ↑ 302.0 1 1

Index Scan using index_order_products_on_order_id on order_products (cost=0.56..161.88 rows=302 width=8) (actual time=0.020..0.020 rows=1 loops=1)

  • Index Cond: (order_id = orders.id)
8. 0.017 0.017 ↑ 1.0 1 1

Index Scan using products_pkey on products (cost=0.43..2.41 rows=1 width=12) (actual time=0.017..0.017 rows=1 loops=1)

  • Index Cond: (id = order_products.product_id)
9. 0.021 0.021 ↑ 23.0 1 1

Index Scan using index_collects_on_product_uid on collects (cost=0.57..21.70 rows=23 width=25) (actual time=0.021..0.021 rows=1 loops=1)

  • Index Cond: ((product_uid)::text = (products.uid)::text)
10. 0.014 0.014 ↑ 4.0 1 1

Index Scan using index_product_collections_on_uid on product_collections (cost=0.42..5.34 rows=4 width=26) (actual time=0.014..0.014 rows=1 loops=1)

  • Index Cond: ((uid)::text = (collects.product_collection_uid)::text)
Planning time : 1.497 ms
Execution time : 0.212 ms