explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ypa

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 456.280 ↑ 1.0 201 1

Limit (cost=4.03..423.58 rows=201 width=234) (actual time=8.429..456.280 rows=201 loops=1)

  • Limit (cost=4.03..423.70 rows=201 width QUERY PLAN
2. 385.758 456.200 ↑ 313.2 201 1

Merge Left Join (cost=4.03..130,776.06 rows=62,952 width=234) (actual time=8.427..456.200 rows=201 loops=1)

  • Merge Cond: ((cp13662.attributes ->> 'Identifiant_unique'::text) = injection.catalog_product_id)
3. 0.356 70.422 ↑ 313.2 201 1

Nested Loop Left Join (cost=3.61..44,993.85 rows=62,952 width=273) (actual time=5.100..70.422 rows=201 loops=1)

4. 66.051 68.860 ↑ 313.2 201 1

Merge Left Join (cost=3.18..11,169.42 rows=62,952 width=72) (actual time=5.068..68.860 rows=201 loops=1)

  • Merge Cond: ((cp13662.attributes ->> 'Identifiant_unique'::text) = ov.catalog_product_id)
  • Filter: (NOT COALESCE(ov.excluded, (COALESCE((common.cast_to_numeric_or_null((((cp13662.attributes || COALESCE((cp13662.extra_values -> 'replace'::text), '{}'::jsonb)) || jsonb_build_object()) ->> 'Identifiant_unique'::text)) = '9323321'::numeric), false) OR COALESCE((common.cast_to_numeric_or_null((((cp13662.attributes || COALESCE((cp13662.extra_values -> 'replace'::text), '{}'::jsonb)) || jsonb_build_object()) ->> 'No_import_export_FR'::text)) = '1'::numeric), false)), false))
5. 2.782 2.782 ↑ 626.4 201 1

Index Scan using product_13662_id_ui on product_13662 cp13662 (cost=0.43..10,535.90 rows=125,905 width=71) (actual time=0.246..2.782 rows=201 loops=1)

  • Index Cond: ((attributes ->> 'Identifiant_unique'::text) > '9774769'::text)
  • Filter: (catalog_structure_id = 13662)
6. 0.006 0.027 ↓ 0.0 0 1

Sort (cost=2.74..2.80 rows=24 width=10) (actual time=0.027..0.027 rows=0 loops=1)

  • Sort Key: ov.catalog_product_id
  • Sort Method: quicksort Memory: 25kB
7. 0.021 0.021 ↓ 0.0 0 1

Index Scan using override_catalog_feed_id_catalog_product_id_idx on override ov (cost=0.42..2.19 rows=24 width=10) (actual time=0.021..0.021 rows=0 loops=1)

  • Index Cond: (catalog_feed_id = 5240)
8. 1.206 1.206 ↑ 1.0 1 201

Index Scan using category_pkey on category categ (cost=0.43..0.53 rows=1 width=205) (actual time=0.005..0.006 rows=1 loops=201)

  • Index Cond: (id = cp13662.catalog_category_id)
9. 0.003 0.020 ↓ 0.0 0 1

Materialize (cost=0.42..9.64 rows=84 width=41) (actual time=0.020..0.020 rows=0 loops=1)

10. 0.001 0.017 ↓ 0.0 0 1

GroupAggregate (cost=0.42..8.59 rows=84 width=41) (actual time=0.017..0.017 rows=0 loops=1)

  • Group Key: injection.catalog_product_id
11. 0.016 0.016 ↓ 0.0 0 1

Index Scan using injection_catalog_structure_mapping_id_catalog_product_id_idx on injection (cost=0.42..6.49 rows=84 width=73) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (catalog_structure_mapping_id = 5240)
12. 0.080 456.280 ↑ 1.0 201 1

Limit (cost=4.03..423.58 rows=201 width=234) (actual time=8.429..456.280 rows=201 loops=1)

13. 385.758 456.200 ↑ 313.2 201 1

Merge Left Join (cost=4.03..130,776.06 rows=62,952 width=234) (actual time=8.427..456.200 rows=201 loops=1)

  • Merge Cond: ((cp13662.attributes ->> 'Identifiant_unique'::text) = injection.catalog_product_id)
14. 0.356 70.422 ↑ 313.2 201 1

Nested Loop Left Join (cost=3.61..44,993.85 rows=62,952 width=273) (actual time=5.100..70.422 rows=201 loops=1)

15. 66.051 68.860 ↑ 313.2 201 1

Merge Left Join (cost=3.18..11,169.42 rows=62,952 width=72) (actual time=5.068..68.860 rows=201 loops=1)

  • Merge Cond: ((cp13662.attributes ->> 'Identifiant_unique'::text) = ov.catalog_product_id)
  • Filter: (NOT COALESCE(ov.excluded, (COALESCE((common.cast_to_numeric_or_null((((cp13662.attributes || COALESCE((cp13662.extra_values -> 'replace'::text), '{}'::jsonb)) || jsonb_build_object()) ->> 'Identifiant_unique'::text)) = '9323321'::numeric), false) OR COALESCE((common.cast_to_numeric_or_null((((cp13662.attributes || COALESCE((cp13662.extra_values -> 'replace'::text), '{}'::jsonb)) || jsonb_build_object()) ->> 'No_import_export_FR'::text)) = '1'::numeric), false)), false))
16. 2.782 2.782 ↑ 626.4 201 1

Index Scan using product_13662_id_ui on product_13662 cp13662 (cost=0.43..10,535.90 rows=125,905 width=71) (actual time=0.246..2.782 rows=201 loops=1)

  • Index Cond: ((attributes ->> 'Identifiant_unique'::text) > '9774769'::text)
  • Filter: (catalog_structure_id = 13662)
17. 0.006 0.027 ↓ 0.0 0 1

Sort (cost=2.74..2.80 rows=24 width=10) (actual time=0.027..0.027 rows=0 loops=1)

  • Sort Key: ov.catalog_product_id
  • Sort Method: quicksort Memory: 25kB
18. 0.021 0.021 ↓ 0.0 0 1

Index Scan using override_catalog_feed_id_catalog_product_id_idx on override ov (cost=0.42..2.19 rows=24 width=10) (actual time=0.021..0.021 rows=0 loops=1)

  • Index Cond: (catalog_feed_id = 5240)
19. 1.206 1.206 ↑ 1.0 1 201

Index Scan using category_pkey on category categ (cost=0.43..0.53 rows=1 width=205) (actual time=0.005..0.006 rows=1 loops=201)

  • Index Cond: (id = cp13662.catalog_category_id)
20. 0.003 0.020 ↓ 0.0 0 1

Materialize (cost=0.42..9.64 rows=84 width=41) (actual time=0.020..0.020 rows=0 loops=1)

21. 0.001 0.017 ↓ 0.0 0 1

GroupAggregate (cost=0.42..8.59 rows=84 width=41) (actual time=0.017..0.017 rows=0 loops=1)

  • Group Key: injection.catalog_product_id
22. 0.016 0.016 ↓ 0.0 0 1

Index Scan using injection_catalog_structure_mapping_id_catalog_product_id_idx on injection (cost=0.42..6.49 rows=84 width=73) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (catalog_structure_mapping_id = 5240)
23. 0.075 357.786 ↓ 0.0 201 1

Execution time: 456.701 ms=234) (cost=0..0 rows=0 width=0) (actual time=5.987..357.786 rows=201 loops=1)

24. 306.593 357.711 ↑ 311.7 201 1

Merge Left Join (cost=4.03..130,183.47 rows=62,650 width=234) (actual time=5.987..357.711 rows=201 loops=1)

  • Merge Cond: ((cp13662.attributes ->> 'Identifiant_unique'::text) = injection.catalog_product_id)
25. 0.376 50.871 ↑ 311.7 201 1

Nested Loop Left Join (cost=3.61..44,812.31 rows=62,650 width=273) (actual time=3.691..50.871 rows=201 loops=1)

26. 45.135 49.490 ↑ 311.7 201 1

Merge Left Join (cost=3.18..11,139.12 rows=62,650 width=72) (actual time=3.623..49.490 rows=201 loops=1)

  • Merge Cond: ((cp13662.attributes ->> 'Identifiant_unique'::text) = ov.catalog_product_id)
  • Filter: (NOT COALESCE(ov.excluded, (COALESCE((common.cast_to_numeric_or_null((((cp13662.attributes || COALESCE((cp13662.extra_values -> 'replace'::text), '{}'::jsonb)) || jsonb_build_object()) ->> 'Identifiant_unique'::text)) = '9323321'::numeric), false) OR COALESCE((common.cast_to_numeric_or_null((((cp13662.attributes || COALESCE((cp13662.extra_values -> 'replace'::text), '{}'::jsonb)) || jsonb_build_object()) ->> 'No_import_export_FR'::text)) = '1'::numeric), false)), false))
27. 4.294 4.294 ↑ 623.4 201 1

Index Scan using product_13662_id_ui on product_13662 cp13662 (cost=0.43..10,508.63 rows=125,299 width=71) (actual time=0.080..4.294 rows=201 loops=1)

  • Index Cond: ((attributes ->> 'Identifiant_unique'::text) > '9774769'::text)
  • Filter: (catalog_structure_id = 13662)
28. 0.008 0.061 ↓ 0.0 0 1

Sort (cost=2.74..2.80 rows=24 width=10) (actual time=0.061..0.061 rows=0 loops=1)

  • Sort Key: ov.catalog_product_id
  • Sort Method: quicksort Memory: 25kB
29. 0.053 0.053 ↓ 0.0 0 1

Index Scan using override_catalog_feed_id_catalog_product_id_idx on override ov (cost=0.42..2.19 rows=24 width=10) (actual time=0.053..0.053 rows=0 loops=1)

  • Index Cond: (catalog_feed_id = 5240)
30. 1.005 1.005 ↑ 1.0 1 201

Index Scan using category_pkey on category categ (cost=0.43..0.53 rows=1 width=205) (actual time=0.005..0.005 rows=1 loops=201)

  • Index Cond: (id = cp13662.catalog_category_id)
31. 0.002 0.247 ↓ 0.0 0 1

Materialize (cost=0.42..10.07 rows=84 width=41) (actual time=0.247..0.247 rows=0 loops=1)

32. 0.000 0.245 ↓ 0.0 0 1

GroupAggregate (cost=0.42..9.02 rows=84 width=41) (actual time=0.245..0.245 rows=0 loops=1)

  • Group Key: injection.catalog_product_id
33. 0.245 0.245 ↓ 0.0 0 1

Index Scan using injection_catalog_structure_mapping_id_catalog_product_id_idx on injection (cost=0.42..6.92 rows=84 width=73) (actual time=0.245..0.245 rows=0 loops=1)

  • Index Cond: (catalog_structure_mapping_id = 5240)
34. 0.075 357.786 ↑ 1.0 201 1

Limit (cost=4.03..423.70 rows=201 width=234) (actual time=5.987..357.786 rows=201 loops=1)

35. 306.593 357.711 ↑ 311.7 201 1

Merge Left Join (cost=4.03..130,183.47 rows=62,650 width=234) (actual time=5.987..357.711 rows=201 loops=1)

  • Merge Cond: ((cp13662.attributes ->> 'Identifiant_unique'::text) = injection.catalog_product_id)
36. 0.376 50.871 ↑ 311.7 201 1

Nested Loop Left Join (cost=3.61..44,812.31 rows=62,650 width=273) (actual time=3.691..50.871 rows=201 loops=1)

37. 45.135 49.490 ↑ 311.7 201 1

Merge Left Join (cost=3.18..11,139.12 rows=62,650 width=72) (actual time=3.623..49.490 rows=201 loops=1)

  • Merge Cond: ((cp13662.attributes ->> 'Identifiant_unique'::text) = ov.catalog_product_id)
  • Filter: (NOT COALESCE(ov.excluded, (COALESCE((common.cast_to_numeric_or_null((((cp13662.attributes || COALESCE((cp13662.extra_values -> 'replace'::text), '{}'::jsonb)) || jsonb_build_object()) ->> 'Identifiant_unique'::text)) = '9323321'::numeric), false) OR COALESCE((common.cast_to_numeric_or_null((((cp13662.attributes || COALESCE((cp13662.extra_values -> 'replace'::text), '{}'::jsonb)) || jsonb_build_object()) ->> 'No_import_export_FR'::text)) = '1'::numeric), false)), false))
38. 4.294 4.294 ↑ 623.4 201 1

Index Scan using product_13662_id_ui on product_13662 cp13662 (cost=0.43..10,508.63 rows=125,299 width=71) (actual time=0.080..4.294 rows=201 loops=1)

  • Index Cond: ((attributes ->> 'Identifiant_unique'::text) > '9774769'::text)
  • Filter: (catalog_structure_id = 13662)
39. 0.008 0.061 ↓ 0.0 0 1

Sort (cost=2.74..2.80 rows=24 width=10) (actual time=0.061..0.061 rows=0 loops=1)

  • Sort Key: ov.catalog_product_id
  • Sort Method: quicksort Memory: 25kB
40. 0.053 0.053 ↓ 0.0 0 1

Index Scan using override_catalog_feed_id_catalog_product_id_idx on override ov (cost=0.42..2.19 rows=24 width=10) (actual time=0.053..0.053 rows=0 loops=1)

  • Index Cond: (catalog_feed_id = 5240)
41. 1.005 1.005 ↑ 1.0 1 201

Index Scan using category_pkey on category categ (cost=0.43..0.53 rows=1 width=205) (actual time=0.005..0.005 rows=1 loops=201)

  • Index Cond: (id = cp13662.catalog_category_id)
42. 0.002 0.247 ↓ 0.0 0 1

Materialize (cost=0.42..10.07 rows=84 width=41) (actual time=0.247..0.247 rows=0 loops=1)

43. 0.000 0.245 ↓ 0.0 0 1

GroupAggregate (cost=0.42..9.02 rows=84 width=41) (actual time=0.245..0.245 rows=0 loops=1)

  • Group Key: injection.catalog_product_id
44. 0.245 0.245 ↓ 0.0 0 1

Index Scan using injection_catalog_structure_mapping_id_catalog_product_id_idx on injection (cost=0.42..6.92 rows=84 width=73) (actual time=0.245..0.245 rows=0 loops=1)

  • Index Cond: (catalog_structure_mapping_id = 5240)
Planning time : 4.789 ms
Execution time : 358.269 ms