All pastes #992202 Raw Edit

Untitled

public text v1 · immutable
#992202 ·published 2008-04-21 17:52 UTC
rendered paste body
explain analyze delete from products where product_id = 415293;
                                                       QUERY PLAN                                                       
------------------------------------------------------------------------------------------------------------------------
 Index Scan using products_pkey on products  (cost=0.00..8.30 rows=1 width=6) (actual time=0.100..0.103 rows=1 loops=1)
   Index Cond: (product_id = 415293)
 Trigger for constraint models_products_product_fkey: time=0.145 calls=1
 Trigger for constraint parts_product_fkey: time=0.159 calls=1
 Trigger for constraint product_brands_product_fkey: time=0.076 calls=1
 Trigger for constraint product_categories_product_fkey: time=0.073 calls=1
 Trigger for constraint product_descriptions_product_fkey: time=0.154 calls=1
 Trigger for constraint product_features_product_fkey: time=0.072 calls=1
 Trigger for constraint product_files_product_fkey: time=0.068 calls=1
 Trigger for constraint product_images_product_fkey: time=0.071 calls=1
 Trigger for constraint product_quantities_product_fkey: time=0.137 calls=1
 Total runtime: 263.746 ms
(12 rows)