explain.depesz.com

A tool for finding a real cause for slow queries.

Result: Ajy

options
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0
→

Limit (cost=106.60..220.50 rows=1 width=134) (actual time=.. rows= loops=)

2. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=106.60..220.50 rows=1 width=134) (actual time=.. rows= loops=)

3. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=106.60..220.19 rows=1 width=110) (actual time=.. rows= loops=)

4. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=106.60..211.91 rows=1 width=110) (actual time=.. rows= loops=)

  • Join Filter: ((article0_.id_measure_unit)::bigint = (measureuni2_.id)::bigint)
5. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=106.60..210.21 rows=1 width=114) (actual time=.. rows= loops=)

6. 0.000 0.000 ↓ 0.0
→

Nested Loop Left Join (cost=106.60..201.93 rows=1 width=90) (actual time=.. rows= loops=)

  • Filter: (saleprice6_.default_price OR (articlesal5_.id IS NULL))
7. 0.000 0.000 ↓ 0.0
→

Hash Right Join (cost=106.60..201.35 rows=2 width=106) (actual time=.. rows= loops=)

  • Hash Cond: ((articlesal5_.id_article)::bigint = (article0_.id)::bigint)
8. 0.000 0.000 ↓ 0.0
→

Seq Scan on article_sale_price articlesal5_ (cost=0.00..79.53 rows=4053 width=30) (actual time=.. rows= loops=)

9. 0.000 0.000 ↓ 0.0
→

Hash (cost=106.59..106.59 rows=1 width=84) (actual time=.. rows= loops=)

10. 0.000 0.000 ↓ 0.0
→

Hash Right Join (cost=79.67..106.59 rows=1 width=84) (actual time=.. rows= loops=)

  • Hash Cond: ((articlegro7_.id_article)::bigint = (article0_.id)::bigint)
11. 0.000 0.000 ↓ 0.0
→

Seq Scan on article_group_assignment articlegro7_ (cost=0.00..22.30 rows=1230 width=16) (actual time=.. rows= loops=)

12. 0.000 0.000 ↓ 0.0
→

Hash (cost=79.65..79.65 rows=1 width=84) (actual time=.. rows= loops=)

13. 0.000 0.000 ↓ 0.0
→

Seq Scan on article article0_ (cost=0.00..79.65 rows=1 width=84) (actual time=.. rows= loops=)

  • Filter: (((id_company)::bigint = 1) AND ((lower((article_name)::text) ~~ 'sdf'::text) OR (lower((article_code)::text) ~~ 'asd'::text)))
14. 0.000 0.000 ↓ 0.0
→

Index Scan using "SALE_PRICE_pkey" on sale_price saleprice6_ (cost=0.00..0.28 rows=1 width=9) (actual time=.. rows= loops=)

  • Index Cond: ((articlesal5_.id_sale_price)::bigint = (id)::bigint)
15. 0.000 0.000 ↓ 0.0
→

Index Scan using "ARTICLE_TYPE_pkey" on article_type articletyp1_ (cost=0.00..8.27 rows=1 width=40) (actual time=.. rows= loops=)

  • Index Cond: ((id)::bigint = (article0_.id_article_type)::bigint)
16. 0.000 0.000 ↓ 0.0
→

Seq Scan on measure_unit measureuni2_ (cost=0.00..1.31 rows=31 width=12) (actual time=.. rows= loops=)

17. 0.000 0.000 ↓ 0.0
→

Index Scan using "COMPANY_VAT_RATE_pkey" on company_vat_rate companyvat3_ (cost=0.00..8.27 rows=1 width=16) (actual time=.. rows= loops=)

  • Index Cond: ((id)::bigint = (article0_.id_company_vat_rate)::bigint)
18. 0.000 0.000 ↓ 0.0
→

Index Scan using "VAT_RATE_pkey" on vat_rate vatrate4_ (cost=0.00..0.30 rows=1 width=40) (actual time=.. rows= loops=)

  • Index Cond: ((id)::bigint = (companyvat3_.id_vat_rate)::bigint)