explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Qsol : Optimization for: plan #ZeZR

Settings

Optimization path:

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

Sort (cost=143,934.88..144,853.48 rows=367,442 width=63) (actual rows= loops=)

  • Sort Key: ld."SIGNAL_STR", (count(ld."ID"))
2. 0.000 0.000 ↓ 0.0

HashAggregate (cost=85,536.59..89,211.01 rows=367,442 width=63) (actual rows= loops=)

  • Group Key: ld."MODEM", rm."TITLE", ld."SIGNAL_STR
3. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=3.76..81,862.17 rows=367,442 width=71) (actual rows= loops=)

  • Hash Cond: (ld."MODEM" = rm."ID")
4. 0.000 0.000 ↓ 0.0

Append (cost=0.00..80,873.44 rows=367,442 width=36) (actual rows= loops=)

  • Subplans Removed: 5
5. 0.000 0.000 ↓ 0.0

Index Scan using "RLLD_2020_POINT_TIME_MODEM_idx" on "RLLD_2020" ld (cost=0.44..79,007.82 rows=367,426 width=36) (actual rows= loops=)

  • Index Cond: ("POINT_TIME" >= (now() - '8 days'::interval))
  • Filter: (("SIGNAL_STR" IS NOT NULL) AND ("MODEM" = ANY ('{7f75b63c-f0e8-4f03-9791-d3a448d2eb39,eb659923-5d81-403b-9cc2-1b6639fe8808,4390452b-f369-4978-b9f0-14d18f19e3e1,4ca0251e-3b44-4cfa-be1d-8727a51ec0e5,a05664f9-434b-4d84-8046-046e163764d0,9bdbafb6-a528-483b-b6b7-8d26b9400fb4,7d7a60bc-35c2-4971-89bf-a128480373bc,950751ed-0464-4146-9a85-ca540e93b623,44dc3220-991b-4027-9ea0-8861da00d429,dabffef1-a835-460b-bcd0-c42acef10d0c,20e58695-cd1d-43b0-a5d9-37c8aaa95266,c3b840ed-6b5d-4d69-ad80-d0274cc1e040,ed23af5f-1bc6-4225-b3cf-2515711887b9,72b78727-c143-4103-9aaa-8340fcbc1790,76acafc6-f2a0-4b7b-a58f-c298158bc85e,fe87e7d6-d2b4-4d3a-aa01-b14cc9fc1a6b,40de1042-0e3d-4296-905b-ac8199c4444c,22da19e0-0a67-4c21-a2a3-2174cc7305e1,b494b7bf-f9fa-47fb-839f-24320da6c647}'::uuid[])))
6. 0.000 0.000 ↓ 0.0

Seq Scan on "RLLD_2021" ld_1 (cost=0.00..12.89 rows=6 width=36) (actual rows= loops=)

  • Filter: (("SIGNAL_STR" IS NOT NULL) AND ("POINT_TIME" >= (now() - '8 days'::interval)) AND ("MODEM" = ANY ('{7f75b63c-f0e8-4f03-9791-d3a448d2eb39,eb659923-5d81-403b-9cc2-1b6639fe8808,4390452b-f369-4978-b9f0-14d18f19e3e1,4ca0251e-3b44-4cfa-be1d-8727a51ec0e5,a05664f9-434b-4d84-8046-046e163764d0,9bdbafb6-a528-483b-b6b7-8d26b9400fb4,7d7a60bc-35c2-4971-89bf-a128480373bc,950751ed-0464-4146-9a85-ca540e93b623,44dc3220-991b-4027-9ea0-8861da00d429,dabffef1-a835-460b-bcd0-c42acef10d0c,20e58695-cd1d-43b0-a5d9-37c8aaa95266,c3b840ed-6b5d-4d69-ad80-d0274cc1e040,ed23af5f-1bc6-4225-b3cf-2515711887b9,72b78727-c143-4103-9aaa-8340fcbc1790,76acafc6-f2a0-4b7b-a58f-c298158bc85e,fe87e7d6-d2b4-4d3a-aa01-b14cc9fc1a6b,40de1042-0e3d-4296-905b-ac8199c4444c,22da19e0-0a67-4c21-a2a3-2174cc7305e1,b494b7bf-f9fa-47fb-839f-24320da6c647}'::uuid[])))
7. 0.000 0.000 ↓ 0.0

Hash (cost=2.78..2.78 rows=78 width=51) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on "REF_MODEMS" rm (cost=0.00..2.78 rows=78 width=51) (actual rows= loops=)