explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JmYC

Settings
# exclusive inclusive rows x rows loops node
1. 2.104 38.065 ↑ 1.5 1,145 1

Sort (cost=41,911.99..41,916.39 rows=1,759 width=37) (actual time=37.297..38.065 rows=1,145 loops=1)

  • Sort Key: prm.score DESC, prm.content_id DESC
  • Sort Method: quicksort Memory: 138kB
2. 4.198 35.961 ↑ 1.5 1,145 1

Nested Loop (cost=147.66..41,817.17 rows=1,759 width=37) (actual time=0.732..35.961 rows=1,145 loops=1)

3. 7.797 8.399 ↑ 2.5 1,947 1

Bitmap Heap Scan on product_content_recommendation_main prm (cost=147.23..14,420.58 rows=4,939 width=37) (actual time=0.694..8.399 rows=1,947 loops=1)

  • Recheck Cond: ((content_id = ANY ('{4195645,4419973,3520881,4262541,3097075,3606189,2170061,2118682,2292006,586756}'::bigint[])) AND (version = 1))
  • Heap Blocks: exact=819
4. 0.602 0.602 ↑ 2.5 1,947 1

Bitmap Index Scan on product_content_recommendatio_content_id_recommended_content_vr (cost=0.00..146.00 rows=4,939 width=0) (actual time=0.601..0.602 rows=1,947 loops=1)

  • Index Cond: ((content_id = ANY ('{4195645,4419973,3520881,4262541,3097075,3606189,2170061,2118682,2292006,586756}'::bigint[])) AND (version = 1))
5. 23.364 23.364 ↑ 1.0 1 1,947

Index Scan using pk_product_content on product_content prc (cost=0.43..5.54 rows=1 width=8) (actual time=0.011..0.012 rows=1 loops=1,947)

  • Index Cond: (product_content_id = prm.recommended_content_id)
  • Filter: is_visible
  • Rows Removed by Filter: 0