explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dVg5p

Settings
# exclusive inclusive rows x rows loops node
1. 1,283.894 1,610.287 ↑ 1.0 141,503 1

Sort (cost=127,248.94..127,607.48 rows=143,415 width=103) (actual time=1,411.256..1,610.287 rows=141,503 loops=1)

  • Sort Key: (COALESCE(website_published, false)) DESC, website_sequence DESC, name
  • Sort Method: external merge Disk: 19,120kB
  • Functions: 6
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 5.522 ms, Inlining 0.000 ms, Optimization 2.336 ms, Emission 31.539 ms, Total 39.396 ms
2. 302.623 326.393 ↑ 1.0 141,503 1

Bitmap Heap Scan on product_template (cost=1,512.71..110,371.51 rows=143,415 width=103) (actual time=71.813..326.393 rows=141,503 loops=1)

  • Recheck Cond: (product_brand_id = ANY ('{49141,113535}'::integer[]))
  • Filter: active
  • Heap Blocks: exact=57,088
3. 23.770 23.770 ↑ 1.0 141,503 1

Bitmap Index Scan on product_template_product_brand_id_idx (cost=0.00..1,476.86 rows=143,415 width=0) (actual time=23.770..23.770 rows=141,503 loops=1)

  • Index Cond: (product_brand_id = ANY ('{49141,113535}'::integer[]))
Planning time : 0.447 ms
Execution time : 1,631.032 ms