explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HGTh

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 208,925.314 ↑ 1.0 1 1

Finalize Aggregate (cost=4,383,246.40..4,383,246.41 rows=1 width=8) (actual time=208,925.313..208,925.314 rows=1 loops=1)

2. 155,208.469 208,925.413 ↓ 1.3 4 1

Gather (cost=4,383,246.08..4,383,246.39 rows=3 width=8) (actual time=208,925.303..208,925.413 rows=4 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
3. 283.321 53,716.944 ↑ 1.0 1 4

Partial Aggregate (cost=4,382,246.08..4,382,246.09 rows=1 width=8) (actual time=53,716.944..53,716.944 rows=1 loops=4)

4. 35,110.803 53,433.623 ↓ 1.2 1,328,960 4

Hash Left Join (cost=0.88..4,379,533.79 rows=1,084,918 width=0) (actual time=1,489.815..53,433.623 rows=1,328,960 loops=4)

  • Hash Cond: ((pro.attributes ->> cs.product_identifier) = ov.catalog_product_id)
  • 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.000 18,322.796 ↑ 1.6 1,328,960 4

Nested Loop (cost=0.00..4,346,830.66 rows=2,169,836 width=1,447) (actual time=1,489.037..18,322.796 rows=1,328,960 loops=4)

6. 1,489.019 1,489.019 ↓ 0.0 0 4

Parallel Seq Scan on structure cs (cost=0.00..16,325.82 rows=1 width=8) (actual time=1,489.018..1,489.019 rows=0 loops=4)

  • Filter: (id = 8528)
  • Rows Removed by Filter: 1465
7. 65,880.432 65,880.432 ↑ 1.3 5,315,838 1

Seq Scan on product_8528 pro (cost=0.00..4,263,239.92 rows=6,726,492 width=1,443) (actual time=0.074..65,880.432 rows=5,315,838 loops=1)

8. 0.000 0.024 ↓ 0.0 0 1

Hash (cost=0.82..0.82 rows=5 width=11) (actual time=0.024..0.024 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
9. 0.024 0.024 ↓ 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.024..0.024 rows=0 loops=1)

  • Index Cond: (catalog_feed_id = 16045)
Planning time : 3.579 ms
Execution time : 208,925.532 ms