explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ueZt

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.116 ↑ 1.0 1 1

Limit (cost=172.12..172.12 rows=1 width=89) (actual time=0.116..0.116 rows=1 loops=1)

2. 0.000 0.115 ↑ 43.0 1 1

Unique (cost=172.12..172.23 rows=43 width=89) (actual time=0.115..0.115 rows=1 loops=1)

3. 0.023 0.115 ↑ 43.0 1 1

Sort (cost=172.12..172.23 rows=43 width=89) (actual time=0.115..0.115 rows=1 loops=1)

  • Sort Key: lowest_price_cents
  • Sort Method: quicksort Memory: 32kB
4. 0.092 0.092 ↓ 1.3 54 1

Index Scan using idx_product_variants_on_pt_and_sales_channel_and_shoe_condition on product_variants (cost=0.43..170.96 rows=43 width=89) (actual time=0.020..0.092 rows=54 loops=1)

  • Index Cond: ((product_template_id = 116663) AND (sales_channel_id = 1))
Planning time : 0.319 ms
Execution time : 0.139 ms