explain.depesz.com

PostgreSQL's explain analyze made readable

Result: njmS

Settings
# exclusive inclusive rows x rows loops node
1. 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)

2. 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)
3. 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)

4. 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))
5. 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)
6. 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
7. 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)
8. 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)
9. 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)

10. 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
11. 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