# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.000 | 0.000 | ↓ 0.0 |
→
Merge Join (cost=541,167.96..554,239.21 rows=739,973 width=1,262) (actual rows= loops=)
|
||
2. | 0.000 | 0.000 | ↓ 0.0 |
→
Merge Join (cost=3,233.35..3,338.02 rows=6,764 width=1,262) (actual rows= loops=)
|
||
3. | 0.000 | 0.000 | ↓ 0.0 | |||
4. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using messages_org_part_25_event_created_idx on messages_org_part_25 m (cost=0.42..1,331.39 rows=643 width=16) (actual rows= loops=)
|
||
5. | 0.000 | 0.000 | ↓ 0.0 |
→
Sort (cost=1,871.96..1,877.22 rows=2,104 width=1,246) (actual rows= loops=)
|
||
6. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using events_org_part_25_created_idx on events_org_part_25 e (cost=0.42..1,755.83 rows=2,104 width=1,246) (actual rows= loops=)
|
||
7. | 0.000 | 0.000 | ↓ 0.0 |
→
Sort (cost=537,934.61..537,989.31 rows=21,880 width=16) (actual rows= loops=)
|
||
8. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop (cost=1.11..536,357.36 rows=21,880 width=16) (actual rows= loops=) |
||
9. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using groups_org_part_default_pkey on groups_org_part_default gr (cost=0.55..226.17 rows=1 width=16) (actual rows= loops=)
|
||
10. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx35 on notifications_summary_weekly_partitioned_2019_w40 ns (cost=0.56..536,130.45 rows=74 width=32) (actual rows= loops=)
|