explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QODU

Settings
# exclusive inclusive rows x rows loops node
1. 3.766 14.700 ↑ 53.5 1,294 1

Nested Loop (cost=2.00..506,048.99 rows=69,174 width=9) (actual time=0.095..14.700 rows=1,294 loops=1)

2. 2.249 4.464 ↑ 53.5 1,294 1

Nested Loop (cost=1.57..142,112.50 rows=69,174 width=16) (actual time=0.083..4.464 rows=1,294 loops=1)

  • Join Filter: (prm.content_id = prc2.content_id)
3. 0.069 0.295 ↑ 7.5 16 1

Nested Loop (cost=1.00..4,287.78 rows=120 width=16) (actual time=0.058..0.295 rows=16 loops=1)

4. 0.101 0.101 ↑ 13.9 25 1

Index Scan using product_content_recommendation_main2_recommended_content_id_asi on product_content_recommendation_main2 prm (cost=0.57..2,064.57 rows=348 width=8) (actual time=0.042..0.101 rows=25 loops=1)

  • Index Cond: (recommended_content_id = 759019)
  • Filter: (version = 2)
  • Rows Removed by Filter: 16
5. 0.125 0.125 ↑ 1.0 1 25

Index Scan using pk_product_content on product_content prc (cost=0.43..6.38 rows=1 width=8) (actual time=0.004..0.005 rows=1 loops=25)

  • Index Cond: (product_content_id = prm.content_id)
  • Filter: is_visible
  • Rows Removed by Filter: 0
6. 1.920 1.920 ↑ 5.8 81 16

Index Only Scan using product_content_recommendatio_content_id_recommended_content_ve on product_content_recommendation_main2 prc2 (cost=0.57..1,142.66 rows=470 width=16) (actual time=0.012..0.120 rows=81 loops=16)

  • Index Cond: ((content_id = prc.product_content_id) AND (version = 2))
  • Heap Fetches: 1294
7. 6.470 6.470 ↑ 1.0 1 1,294

Index Scan using pk_product_content on product_content pc2 (cost=0.43..5.25 rows=1 width=9) (actual time=0.004..0.005 rows=1 loops=1,294)

  • Index Cond: (product_content_id = prc2.recommended_content_id)