explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RgG7

Settings
# exclusive inclusive rows x rows loops node
1. 1,665.501 2,088.946 ↑ 1.0 193,106 1

Sort (cost=152,644.47..153,129.81 rows=194,136 width=103) (actual time=2,060.701..2,088.946 rows=193,106 loops=1)

  • Sort Key: (COALESCE(website_published, false)) DESC, website_sequence DESC, name
  • Sort Method: quicksort Memory: 45,910kB
  • Functions: 6
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 5.388 ms, Inlining 0.000 ms, Optimization 2.186 ms, Emission 37.804 ms, Total 45.378 ms
2. 395.008 423.445 ↑ 1.0 193,106 1

Bitmap Heap Scan on product_template (cost=2,031.20..135,592.82 rows=194,136 width=103) (actual time=85.315..423.445 rows=193,106 loops=1)

  • Recheck Cond: (product_brand_id = ANY ('{49141,63080}'::integer[]))
  • Filter: active
  • Heap Blocks: exact=66,899
3. 28.437 28.437 ↑ 1.0 193,106 1

Bitmap Index Scan on product_template_product_brand_id_idx (cost=0.00..1,982.67 rows=194,136 width=0) (actual time=28.437..28.437 rows=193,106 loops=1)

  • Index Cond: (product_brand_id = ANY ('{49141,63080}'::integer[]))
Planning time : 0.282 ms
Execution time : 2,118.455 ms