explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0bk

Settings
# exclusive inclusive rows x rows loops node
1. 1,736.267 760,433.734 ↑ 1.0 3,191,462 1

Unique (cost=11,550,464.24..11,798,466.33 rows=3,200,027 width=1,975) (actual time=751,852.462..760,433.734 rows=3,191,462 loops=1)

2. 91,152.440 758,697.467 ↑ 1.0 3,191,462 1

Sort (cost=11,550,464.24..11,558,464.31 rows=3,200,027 width=1,975) (actual time=751,852.461..758,697.467 rows=3,191,462 loops=1)

  • Sort Key: master.id, master.creation_date, master.last_updated_date, master.checksum, master.data, master.deduplication_status, master.deduplication_date, master.merging_status, master.validation_status, master.validation_report, master.merge_configuration, master.product_id, master.provider_id, master.provider_variant_group_identifier, master.provider_unique_identifier, master.category_code, master.brand, master.variant_group_status, product.creation_date, product.last_updated_date, product.export_update_date, product.operator_unique_identifier, product.approval_status, product.synchronization_status, product.rejection_reason_id, product.rejection_message, product.integration_error_report, product.variant_group_id
  • Sort Method: external merge Disk: 4852768kB
3. 614,899.406 667,545.027 ↑ 1.0 3,191,462 1

Hash Join (cost=260,933.29..3,001,508.38 rows=3,200,027 width=1,975) (actual time=35,787.348..667,545.027 rows=3,191,462 loops=1)

  • Hash Cond: (master.product_id = product.id)
4. 16,981.346 16,981.346 ↑ 1.0 3,191,462 1

Seq Scan on product_data_sheet master (cost=0.00..1,238,870.65 rows=3,200,027 width=1,652) (actual time=0.948..16,981.346 rows=3,191,462 loops=1)

  • Filter: (product_data_sheet_type = 'masterProductDataSheet'::text)
  • Rows Removed by Filter: 3177020
5. 34,634.840 35,664.275 ↑ 1.0 3,191,462 1

Hash (cost=83,831.13..83,831.13 rows=3,192,813 width=323) (actual time=35,664.275..35,664.275 rows=3,191,462 loops=1)

  • Buckets: 16384 Batches: 512 Memory Usage: 919kB
6. 1,029.435 1,029.435 ↑ 1.0 3,191,462 1

Seq Scan on product (cost=0.00..83,831.13 rows=3,192,813 width=323) (actual time=0.017..1,029.435 rows=3,191,462 loops=1)