explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NziEm

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

Sort (cost=152,644.47..153,129.81 rows=194,136 width=103) (actual time=2,167.610..2,199.574 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.834 ms, Inlining 0.000 ms, Optimization 2.545 ms, Emission 22.034 ms, Total 31.413 ms
2. 355.610 388.425 ↑ 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=72.999..388.425 rows=193,106 loops=1)

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

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