explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DXyT

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

Sort (cost=152,644.47..153,129.81 rows=194,136 width=103) (actual time=2,157.157..2,194.320 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 6.868 ms, Inlining 0.000 ms, Optimization 2.230 ms, Emission 21.747 ms, Total 30.845 ms
2. 320.426 346.254 ↑ 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=65.534..346.254 rows=193,106 loops=1)

  • Recheck Cond: (product_brand_id = ANY ('{49141,63080}'::integer[]))
  • Filter: active
  • Heap Blocks: exact=66,899
3. 25.828 25.828 ↑ 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=25.828..25.828 rows=193,106 loops=1)

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