explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4Aov

Settings
# exclusive inclusive rows x rows loops node
1. 441.128 17,921.761 ↓ 119.0 44,516 1

Nested Loop Left Join (cost=11.81..1,340,457.69 rows=374 width=410) (actual time=13.206..17,921.761 rows=44,516 loops=1)

2. 8.225 17,079.989 ↓ 119.0 44,516 1

Nested Loop (cost=1.40..1,336,519.19 rows=374 width=1,073) (actual time=13.171..17,079.989 rows=44,516 loops=1)

3. 0.013 0.013 ↑ 1.0 1 1

Index Only Scan using offering_pkey on offering o (cost=0.28..8.30 rows=1 width=4) (actual time=0.012..0.013 rows=1 loops=1)

  • Index Cond: (offering_id = 2830)
  • Heap Fetches: 1
4. 37.250 17,071.751 ↓ 119.0 44,516 1

Nested Loop (cost=1.11..1,336,507.16 rows=374 width=1,077) (actual time=13.159..17,071.751 rows=44,516 loops=1)

  • Join Filter: ((op.product_id)::text = (pt.product_id)::text)
5. 32.569 1,320.353 ↑ 1.6 44,516 1

Nested Loop (cost=0.86..446,792.97 rows=70,823 width=1,124) (actual time=0.135..1,320.353 rows=44,516 loops=1)

6. 174.280 174.280 ↓ 1.1 79,536 1

Index Scan using offering_product_offering_fk_idx on offering_product op (cost=0.43..97,823.45 rows=70,823 width=45) (actual time=0.018..174.280 rows=79,536 loops=1)

  • Index Cond: (offering_id = 2830)
7. 1,113.504 1,113.504 ↑ 1.0 1 79,536

Index Scan using product_nouveau_pkey on product_nouveau p (cost=0.43..4.92 rows=1 width=1,079) (actual time=0.014..0.014 rows=1 loops=79,536)

  • Index Cond: ((product_id)::text = (op.product_id)::text)
8. 15,714.148 15,714.148 ↑ 5.0 1 44,516

Function Scan on product_translation_vw pt (cost=0.25..12.75 rows=5 width=32) (actual time=0.353..0.353 rows=1 loops=44,516)

  • Filter: ((p.product_id)::text = (product_id)::text)
9. 89.032 400.644 ↑ 1.0 1 44,516

Aggregate (cost=10.42..10.43 rows=1 width=32) (actual time=0.009..0.009 rows=1 loops=44,516)

10. 0.000 311.612 ↓ 0.0 0 44,516

Nested Loop (cost=0.43..10.41 rows=2 width=516) (actual time=0.007..0.007 rows=0 loops=44,516)

  • Join Filter: (top.tag_id = t.tag_id)
  • Rows Removed by Join Filter: 0
11. 89.032 89.032 ↑ 1.0 5 44,516

Seq Scan on tag t (cost=0.00..1.05 rows=5 width=520) (actual time=0.001..0.002 rows=5 loops=44,516)

12. 89.032 222.580 ↓ 0.0 0 222,580

Materialize (cost=0.43..9.21 rows=2 width=4) (actual time=0.001..0.001 rows=0 loops=222,580)

13. 133.548 133.548 ↓ 0.0 0 44,516

Index Scan using tags_op_op_fk_idx on tag_offering_product top (cost=0.43..9.20 rows=2 width=4) (actual time=0.003..0.003 rows=0 loops=44,516)

  • Index Cond: (offering_product_id = op.offering_product_id)
Planning time : 1.136 ms
Execution time : 17,926.232 ms