explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FkvR

Settings
# exclusive inclusive rows x rows loops node
1. 0.113 515.213 ↑ 1.0 201 1

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

2. 458.488 515.100 ↑ 313.2 201 1

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

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

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

4. 53.027 54.031 ↑ 313.2 201 1

Merge Left Join (cost=3.18..11,169.42 rows=62,952 width=72) (actual time=0.469..54.031 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. 0.988 0.988 ↑ 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.034..0.988 rows=201 loops=1)

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

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

  • Sort Key: ov.catalog_product_id
  • Sort Method: quicksort Memory: 25kB
7. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

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

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

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

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

10. 0.000 0.022 ↓ 0.0 0 1

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

  • Group Key: injection.catalog_product_id
11. 0.023 0.023 ↓ 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.022..0.023 rows=0 loops=1)

  • Index Cond: (catalog_structure_mapping_id = 5240)
Planning time : 1.912 ms
Execution time : 515.647 ms