explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RJNc

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Gather (cost=1,000.00..1,243,893,805.03 rows=268,132 width=207) (actual rows= loops=)

  • Workers Planned: 2
2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.00..1,243,865,991.83 rows=111,722 width=207) (actual rows= loops=)

  • Join Filter: (((table_1562430192952_2075."coopBrandId" = table_1562430289859_2257."coopBrandId") OR ((table_1562430192952_2075."coopBrandId" IS NULL) AND (table_1562430289859_2257."coopBrandId" IS NULL))) AND ((table_1562430192952_2075."coopProductId" = table_1562430289859_2257."coopProductId") OR ((table_1562430192952_2075."coopProductId" IS NULL) AND (table_1562430289859_2257."coopProductId" IS NULL))) AND ((table_1562430192952_2075."podPosition" = table_1562430289859_2257."podPosition") OR ((table_1562430192952_2075."podPosition" IS NULL) AND (table_1562430289859_2257."podPosition" IS NULL))) AND ((table_1562430192952_2075."dmaCode" = table_1562430289859_2257."dmaCode") OR ((table_1562430192952_2075."dmaCode" IS NULL) AND (table_1562430289859_2257."dmaCode" IS NULL))) AND (((table_1562430192952_2075."obsoletedBy")::text = (table_1562430289859_2257."obsoletedBy")::text) OR ((table_1562430192952_2075."obsoletedBy" IS NULL) AND (table_1562430289859_2257."obsoletedBy" IS NULL))) AND ((table_1562430192952_2075."categoryId" = table_1562430289859_2257."categoryId") OR ((table_1562430192952_2075."categoryId" IS NULL) AND (table_1562430289859_2257."categoryId" IS NULL))) AND ((table_1562430192952_2075."coopCateyId") OR ((table_1562430192952_2075."coopCategoryId" IS NULL) AND (table_1562430289859_2257."coopCategoryId" IS NULL))) AND ((table_1562430192952_2075."expiresOn" = table_1562430289859_2257."expiresOn") OR ((table_1562430192952_2075."expiresOn" IS NULL) AND (table_1562430289859_2257."expiresOn" IS NULL))) AND (((table_1562430192952_2075."countryCode")::text = (table_1562430289859_2257."countryCode")::text) OR ((table_1562430192952_2075."countryCode" IS NULL) AND (table_1562430289859_2257."countryCode" IS NULL))) AND ((table_1562430192952_2075."fyiProgramId" = table_1562430289859_2257."fyiProgramId") OR ((table_1562430192952_2075."fyiProgramId" IS NULL) AND (table_1562430289859_2257."fyiProgramId" IS NULL))))
3. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on table_1562430192952_2075 (cost=0.00..8,546.22 rows=111,722 width=199) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on table_1562430289859_2257 (cost=0.00..3,790.89 rows=209,789 width=75) (actual rows= loops=)