explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Fjou

Settings
# exclusive inclusive rows x rows loops node
1. 1,054.775 398,149.209 ↑ 1.0 1 1

Aggregate (cost=4,953,612.25..4,953,612.26 rows=1 width=8) (actual time=398,149.208..398,149.209 rows=1 loops=1)

2.          

CTE pro

3. 179,180.945 179,180.945 ↑ 2.6 5,295,909 1

Seq Scan on product_8528 cp8528 (cost=0.00..4,333,548.54 rows=13,757,354 width=1,441) (actual time=0.157..179,180.945 rows=5,295,909 loops=1)

4. 157,228.752 397,094.434 ↑ 1.3 5,295,909 1

Hash Right Join (cost=584,688.34..602,867.02 rows=6,878,677 width=0) (actual time=239,927.248..397,094.434 rows=5,295,909 loops=1)

  • Hash Cond: (ov.catalog_product_id = (pro.attributes ->> cs.product_identifier))
  • Filter: (NOT COALESCE(ov.excluded, COALESCE((common.cast_to_numeric_or_null(COALESCE(((pro.extra_values -> 'replace'::text) ->> 'price'::text), (pro.attributes ->> 'price'::text))) <= '20'::numeric), false)))
5. 0.015 0.015 ↓ 0.0 0 1

Index Scan using override_catalog_feed_id_catalog_product_id_idx on override ov (cost=0.29..0.82 rows=5 width=11) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (catalog_feed_id = 16045)
6. 48,810.883 239,865.667 ↑ 2.6 5,295,909 1

Hash (cost=412,721.13..412,721.13 rows=13,757,354 width=72) (actual time=239,865.667..239,865.667 rows=5,295,909 loops=1)

  • Buckets: 16777216 (originally 16777216) Batches: 2 (originally 1) Memory Usage: 4063234kB
7. 960.680 191,054.784 ↑ 2.6 5,295,909 1

Nested Loop (cost=0.29..412,721.13 rows=13,757,354 width=72) (actual time=0.222..191,054.784 rows=5,295,909 loops=1)

8. 0.075 0.075 ↑ 1.0 1 1

Index Scan using structure_pkey on structure cs (cost=0.29..0.51 rows=1 width=8) (actual time=0.056..0.075 rows=1 loops=1)

  • Index Cond: (id = 8528)
9. 190,094.029 190,094.029 ↑ 2.6 5,295,909 1

CTE Scan on pro (cost=0.00..275,147.08 rows=13,757,354 width=68) (actual time=0.161..190,094.029 rows=5,295,909 loops=1)

Planning time : 0.357 ms
Execution time : 399,390.432 ms