explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XPfy

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

Aggregate (cost=167,103.31..167,103.32 rows=1 width=8) (actual rows= loops=)

2.          

CTE pool

3. 0.000 0.000 ↓ 0.0

HashAggregate (cost=15,457.76..15,623.55 rows=16,579 width=6) (actual rows= loops=)

  • Group Key: "WebExport_IMPROVEMENT_DETAIL$GQu6rE5LOrCZJ2zNTE32lg=="."Property ID
4. 0.000 0.000 ↓ 0.0

Gather (cost=1,000.00..15,409.15 rows=19,445 width=6) (actual rows= loops=)

  • Workers Planned: 2
5. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "WebExport_IMPROVEMENT_DETAIL$GQu6rE5LOrCZJ2zNTE32lg==" (cost=0.00..12,464.65 rows=8,102 width=6) (actual rows= loops=)

  • Filter: ((lower("Description") ~~ '%pool%'::text) OR ("Description" ~~ '%PP%'::text))
6.          

CTE bedrooms

7. 0.000 0.000 ↓ 0.0

HashAggregate (cost=21,376.72..21,805.66 rows=42,894 width=10) (actual rows= loops=)

  • Group Key: "WebExport_IMPROVEMENT_DETAIL_FEATURE$n0R5E3wtMmesJwapHulrfA=="."Property ID", sum(("WebExport_IMPROVEMENT_DETAIL_FEATURE$n0R5E3wtMmesJwapHulrfA=="."UP/Adj")::real)
8. 0.000 0.000 ↓ 0.0

HashAggregate (cost=20,733.31..21,162.25 rows=42,894 width=10) (actual rows= loops=)

  • Group Key: "WebExport_IMPROVEMENT_DETAIL_FEATURE$n0R5E3wtMmesJwapHulrfA=="."Property ID
9. 0.000 0.000 ↓ 0.0

Seq Scan on "WebExport_IMPROVEMENT_DETAIL_FEATURE$n0R5E3wtMmesJwapHulrfA==" (cost=0.00..20,008.94 rows=72,437 width=11) (actual rows= loops=)

  • Filter: ("Feature" = 'Bedrooms'::text)
10.          

CTE bathrooms

11. 0.000 0.000 ↓ 0.0

HashAggregate (cost=21,360.12..21,785.54 rows=42,542 width=10) (actual rows= loops=)

  • Group Key: "WebExport_IMPROVEMENT_DETAIL_FEATURE$n0R5E3wtMmesJwapHulrfA==_1"."Property ID", sum(("WebExport_IMPROVEMENT_DETAIL_FEATURE$n0R5E3wtMmesJwapHulrfA==_1"."UP/Adj")::real)
12. 0.000 0.000 ↓ 0.0

HashAggregate (cost=20,721.99..21,147.41 rows=42,542 width=10) (actual rows= loops=)

  • Group Key: "WebExport_IMPROVEMENT_DETAIL_FEATURE$n0R5E3wtMmesJwapHulrfA==_1"."Property ID
13. 0.000 0.000 ↓ 0.0

Seq Scan on "WebExport_IMPROVEMENT_DETAIL_FEATURE$n0R5E3wtMmesJwapHulrfA==" "WebExport_IMPROVEMENT_DETAIL_FEATURE$n0R5E3wtMmesJwapHulrfA==_1" (cost=0.00..20,008.94 rows=71,305 width=11) (actual rows= loops=)

  • Filter: ("Feature" = 'Bathrooms'::text)
14. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=101,854.29..106,870.31 rows=407,300 width=0) (actual rows= loops=)

  • Hash Cond: (bathrooms."Property ID" = property."Property ID")
15. 0.000 0.000 ↓ 0.0

CTE Scan on bathrooms (cost=0.00..850.84 rows=42,542 width=32) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Hash (cost=95,171.04..95,171.04 rows=407,300 width=6) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=53,657.03..95,171.04 rows=407,300 width=6) (actual rows= loops=)

  • Hash Cond: (('FLINR'::text || nal."Parcel Identification Code/Geo ID") = last."PropertyID")
18. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=46,976.37..76,176.88 rows=407,300 width=29) (actual rows= loops=)

  • Hash Cond: (btrim(COALESCE(land."Primary Use", imprv2."Type")) = lpad("Sheet1$VNJcGmL5PK2TTEAUE/Z10A=="."Property Use Code", 4, '0'::text))
19. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=46,971.20..70,754.62 rows=407,300 width=39) (actual rows= loops=)

  • Hash Cond: (imprv."Property ID" = property."Property ID")
20. 0.000 0.000 ↓ 0.0

Seq Scan on "WebExport_IMPROVEMENT_DETAIL$GQu6rE5LOrCZJ2zNTE32lg==" imprv (cost=0.00..13,702.49 rows=457,049 width=6) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Hash (cost=45,094.87..45,094.87 rows=92,346 width=39) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=38,943.29..45,094.87 rows=92,346 width=39) (actual rows= loops=)

  • Hash Cond: (owner."Property ID" = property."Property ID")
23. 0.000 0.000 ↓ 0.0

Seq Scan on "WebExport_OWNER$QAWqQUuxOneL5LJ1y5h4sw==" owner (cost=0.00..3,306.19 rows=103,716 width=6) (actual rows= loops=)

  • Filter: ("Primary Owner Indicator" = 'Y'::text)
24. 0.000 0.000 ↓ 0.0

Hash (cost=37,068.98..37,068.98 rows=92,265 width=39) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=31,930.73..37,068.98 rows=92,265 width=39) (actual rows= loops=)

  • Hash Cond: (land."Property ID" = property."Property ID")
26. 0.000 0.000 ↓ 0.0

Seq Scan on "WebExport_LAND$DiJwZDcQMOaFJgfuwq5F5Q==" land (cost=0.00..2,559.79 rows=82,779 width=11) (actual rows= loops=)

27. 0.000 0.000 ↓ 0.0

Hash (cost=30,056.42..30,056.42 rows=92,265 width=34) (actual rows= loops=)

28. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=25,201.81..30,056.42 rows=92,265 width=34) (actual rows= loops=)

  • Hash Cond: (imprv2."Property ID" = property."Property ID")
29. 0.000 0.000 ↓ 0.0

Seq Scan on "WebExport_IMPROVEMENT$81RZUUrSOeaPdRBLyEA9ZQ==" imprv2 (cost=0.00..2,177.26 rows=91,226 width=11) (actual rows= loops=)

30. 0.000 0.000 ↓ 0.0

Hash (cost=23,417.49..23,417.49 rows=92,265 width=29) (actual rows= loops=)

31. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=20,797.84..23,417.49 rows=92,265 width=29) (actual rows= loops=)

  • Hash Cond: (bedrooms."Property ID" = property."Property ID")
32. 0.000 0.000 ↓ 0.0

CTE Scan on bedrooms (cost=0.00..857.88 rows=42,894 width=32) (actual rows= loops=)

33. 0.000 0.000 ↓ 0.0

Hash (cost=19,013.53..19,013.53 rows=92,265 width=29) (actual rows= loops=)

34. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=17,613.17..19,013.53 rows=92,265 width=29) (actual rows= loops=)

  • Hash Cond: (pool."Property ID" = property."Property ID")
35. 0.000 0.000 ↓ 0.0

CTE Scan on pool (cost=0.00..331.58 rows=16,579 width=32) (actual rows= loops=)

36. 0.000 0.000 ↓ 0.0

Hash (cost=15,828.86..15,828.86 rows=92,265 width=29) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=7,059.56..15,828.86 rows=92,265 width=29) (actual rows= loops=)

  • Hash Cond: (nal."Parcel Identification Code/Geo ID" = property."Geo ID")
38. 0.000 0.000 ↓ 0.0

Seq Scan on "WebExport_NAL$Igacit7+OrCXkUJpZSP4Kw==" nal (cost=0.00..5,709.65 rows=92,265 width=23) (actual rows= loops=)

39. 0.000 0.000 ↓ 0.0

Hash (cost=5,055.25..5,055.25 rows=103,625 width=27) (actual rows= loops=)

40. 0.000 0.000 ↓ 0.0

Seq Scan on "WebExport_PROPERTY$5f7/LOnLMTWg7kpAR/tMCg==" property (cost=0.00..5,055.25 rows=103,625 width=27) (actual rows= loops=)

41. 0.000 0.000 ↓ 0.0

Hash (cost=3.41..3.41 rows=141 width=5) (actual rows= loops=)

42. 0.000 0.000 ↓ 0.0

Seq Scan on "Sheet1$VNJcGmL5PK2TTEAUE/Z10A==" (cost=0.00..3.41 rows=141 width=5) (actual rows= loops=)

43. 0.000 0.000 ↓ 0.0

Hash (cost=4,889.07..4,889.07 rows=92,607 width=28) (actual rows= loops=)

44. 0.000 0.000 ↓ 0.0

Seq Scan on "FL Indian River Property Table Last" last (cost=0.00..4,889.07 rows=92,607 width=28) (actual rows= loops=)