explain.depesz.com

PostgreSQL's explain analyze made readable

Result: V3R9

Settings
# exclusive inclusive rows x rows loops node
1. 397.277 21,355.042 ↓ 1.3 2,015,604 1

Gather (cost=86,011.09..1,656,719.39 rows=1,533,947 width=26) (actual time=20,373.476..21,355.042 rows=2,015,604 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 1,043.414 20,957.765 ↓ 1.1 671,868 3

Parallel Hash Join (cost=85,011.09..1,502,324.69 rows=639,145 width=26) (actual time=20,377.038..20,957.765 rows=671,868 loops=3)

  • Hash Cond: (clean_data_inputs.product_settings_id = product_settings.id)
3. 18,623.197 18,623.197 ↑ 1.3 1,267,718 3

Parallel Seq Scan on clean_data_inputs (cost=0.00..1,392,827.33 rows=1,623,245 width=4) (actual time=556.463..18,623.197 rows=1,267,718 loops=3)

  • Filter: (enterprise_id = 18)
  • Rows Removed by Filter: 20496463
4. 205.185 1,291.154 ↑ 1.2 368,941 3

Parallel Hash (cost=76,374.37..76,374.37 rows=446,618 width=30) (actual time=1,291.153..1,291.154 rows=368,941 loops=3)

  • Buckets: 65536 Batches: 32 Memory Usage: 2752kB
5. 277.442 1,085.969 ↑ 1.2 368,941 3

Hash Join (cost=209.80..76,374.37 rows=446,618 width=30) (actual time=4.692..1,085.969 rows=368,941 loops=3)

  • Hash Cond: (product_settings.ppg_id = product_hierarchies.id)
6. 803.927 803.927 ↑ 1.3 907,426 3

Parallel Seq Scan on product_settings (cost=0.00..73,185.83 rows=1,134,283 width=8) (actual time=0.056..803.927 rows=907,426 loops=3)

7. 2.183 4.600 ↑ 1.0 3,991 3

Hash (cost=159.91..159.91 rows=3,991 width=30) (actual time=4.600..4.600 rows=3,991 loops=3)

  • Buckets: 4096 Batches: 1 Memory Usage: 282kB
8. 2.417 2.417 ↑ 1.0 3,991 3

Seq Scan on product_hierarchies (cost=0.00..159.91 rows=3,991 width=30) (actual time=0.025..2.417 rows=3,991 loops=3)

Planning time : 0.938 ms
Execution time : 21,502.192 ms