explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PaUd : Optimization for: asd; plan #sfnh

Settings

Optimization path:

Optimization(s) for this plan:

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

Finalize GroupAggregate (cost=143,650,896.04..143,651,909.11 rows=27 width=12) (actual rows= loops=)

  • Group Key: "R"."TENANT_ID
2. 0.000 0.000 ↓ 0.0

Gather Merge (cost=143,650,896.04..143,651,908.57 rows=54 width=12) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Partial GroupAggregate (cost=143,649,896.01..143,650,902.31 rows=27 width=12) (actual rows= loops=)

  • Group Key: "R"."TENANT_ID
4. 0.000 0.000 ↓ 0.0

Sort (cost=143,649,896.01..143,650,231.36 rows=134,137 width=36) (actual rows= loops=)

  • Sort Key: "R"."TENANT_ID
5. 0.000 0.000 ↓ 0.0

Append (cost=0.00..143,634,804.00 rows=134,137 width=36) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "GDL_READING_2019_12" "R" (cost=0.00..10.10 rows=1 width=36) (actual rows= loops=)

  • Filter: (("HEART_RATE_MIN" > "HEART_RATE_MAX") AND ("PARTNER_SYSTEM_ID" = 21) AND (("DATA_CATEGORY")::text = 'FITNESS'::text))
7. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "GDL_READING_2020_01" "R_1" (cost=0.00..10.10 rows=1 width=36) (actual rows= loops=)

  • Filter: (("HEART_RATE_MIN" > "HEART_RATE_MAX") AND ("PARTNER_SYSTEM_ID" = 21) AND (("DATA_CATEGORY")::text = 'FITNESS'::text))
8. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "GDL_READING_2020_02" "R_2" (cost=0.00..10.15 rows=1 width=36) (actual rows= loops=)

  • Filter: (("HEART_RATE_MIN" > "HEART_RATE_MAX") AND ("PARTNER_SYSTEM_ID" = 21) AND (("DATA_CATEGORY")::text = 'FITNESS'::text))
9. 0.000 0.000 ↓ 0.0

Parallel Bitmap Heap Scan on "GDL_READING_2020_03" "R_3" (cost=12,627,075.83..15,181,543.58 rows=4,093 width=36) (actual rows= loops=)

  • Recheck Cond: ("PARTNER_SYSTEM_ID" = 21)
  • Filter: (("HEART_RATE_MIN" > "HEART_RATE_MAX") AND (("DATA_CATEGORY")::text = 'FITNESS'::text))
10. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "GDL_READING_2020_03_09N" (cost=0.00..12,627,073.37 rows=742,357 width=0) (actual rows= loops=)

  • Index Cond: ("PARTNER_SYSTEM_ID" = 21)
11. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "GDL_READING_2020_04" "R_4" (cost=0.00..26,036,634.10 rows=22,567 width=36) (actual rows= loops=)

  • Filter: (("HEART_RATE_MIN" > "HEART_RATE_MAX") AND ("PARTNER_SYSTEM_ID" = 21) AND (("DATA_CATEGORY")::text = 'FITNESS'::text))
12. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "GDL_READING_2020_05" "R_5" (cost=0.00..28,643,847.87 rows=38,164 width=36) (actual rows= loops=)

  • Filter: (("HEART_RATE_MIN" > "HEART_RATE_MAX") AND ("PARTNER_SYSTEM_ID" = 21) AND (("DATA_CATEGORY")::text = 'FITNESS'::text))
13. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "GDL_READING_2020_06" "R_6" (cost=0.00..27,487,961.67 rows=27,446 width=36) (actual rows= loops=)

  • Filter: (("HEART_RATE_MIN" > "HEART_RATE_MAX") AND ("PARTNER_SYSTEM_ID" = 21) AND (("DATA_CATEGORY")::text = 'FITNESS'::text))
14. 0.000 0.000 ↓ 0.0

Parallel Bitmap Heap Scan on "GDL_READING_2020_07" "R_7" (cost=25,849,272.47..40,514,767.68 rows=35,563 width=36) (actual rows= loops=)

  • Recheck Cond: ("PARTNER_SYSTEM_ID" = 21)
  • Filter: (("HEART_RATE_MIN" > "HEART_RATE_MAX") AND (("DATA_CATEGORY")::text = 'FITNESS'::text))
15. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "GDL_READING_2020_07_03N" (cost=0.00..25,849,251.13 rows=5,257,742 width=0) (actual rows= loops=)

  • Index Cond: ("PARTNER_SYSTEM_ID" = 21)
16. 0.000 0.000 ↓ 0.0

Parallel Bitmap Heap Scan on "GDL_READING_2020_08" "R_8" (cost=3,454,449.77..5,770,010.53 rows=6,300 width=36) (actual rows= loops=)

  • Recheck Cond: ("PARTNER_SYSTEM_ID" = 21)
  • Filter: (("HEART_RATE_MIN" > "HEART_RATE_MAX") AND (("DATA_CATEGORY")::text = 'FITNESS'::text))
17. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "GDL_READING_2020_08_03N" (cost=0.00..3,454,445.98 rows=831,837 width=0) (actual rows= loops=)

  • Index Cond: ("PARTNER_SYSTEM_ID" = 21)
18. 0.000 0.000 ↓ 0.0

Parallel Index Scan using "GDL_READING_2020_09_05N" on "GDL_READING_2020_09" "R_9" (cost=0.14..8.22 rows=1 width=36) (actual rows= loops=)

  • Index Cond: ("PARTNER_SYSTEM_ID" = 21)
  • Filter: (("HEART_RATE_MIN" > "HEART_RATE_MAX") AND (("DATA_CATEGORY")::text = 'FITNESS'::text))