# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 55.844 | 1,111.446 | ↓ 136.0 | 136 | 1 |
→
Nested Loop (cost=3,529.60..10,764.85 rows=1 width=1,048) (actual time=187.485..1,111.446 rows=136 loops=1)
|
2. |
CTE cu |
|||||
3. | 29.668 | 44.196 | ↓ 1.0 | 48,305 | 1 |
→
Hash Join (cost=148.02..2,024.00 rows=48,294 width=45) (actual time=1.589..44.196 rows=48,305 loops=1)
|
4. | 12.956 | 12.956 | ↓ 1.0 | 48,305 | 1 |
→
Seq Scan on channel_members cm (cost=0.00..1,211.94 rows=48,294 width=32) (actual time=0.007..12.956 rows=48,305 loops=1) |
5. | 0.690 | 1.572 | ↑ 1.0 | 1,734 | 1 |
→
Hash (cost=126.34..126.34 rows=1,734 width=45) (actual time=1.572..1.572 rows=1,734 loops=1)
|
6. | 0.882 | 0.882 | ↑ 1.0 | 1,734 | 1 |
→
Seq Scan on users u (cost=0.00..126.34 rows=1,734 width=45) (actual time=0.004..0.882 rows=1,734 loops=1) |
7. | 37.429 | 184.639 | ↓ 123.0 | 123 | 1 |
→
Hash Right Join (cost=1,505.60..7,651.23 rows=1 width=548) (actual time=184.529..184.639 rows=123 loops=1)
|
8. | 43.022 | 43.022 | ↑ 1.0 | 117,800 | 1 |
→
Seq Scan on messages m (cost=0.00..5,700.37 rows=118,537 width=24) (actual time=0.006..43.022 rows=117,800 loops=1) |
9. | 0.654 | 104.188 | ↓ 182.3 | 1,276 | 1 |
→
Hash (cost=1,505.52..1,505.52 rows=7 width=548) (actual time=104.188..104.188 rows=1,276 loops=1)
|
10. | 2.698 | 103.534 | ↓ 182.3 | 1,276 | 1 |
→
Nested Loop (cost=0.29..1,505.52 rows=7 width=548) (actual time=1.603..103.534 rows=1,276 loops=1) |
11. | 79.942 | 79.942 | ↓ 174.1 | 10,447 | 1 |
→
CTE Scan on cu (cost=0.00..1,086.62 rows=60 width=532) (actual time=1.593..79.942 rows=10,447 loops=1)
|
12. | 20.894 | 20.894 | ↓ 0.0 | 0 | 10,447 |
→
Index Scan using channels_pkey on channels c (cost=0.29..6.97 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=10,447)
|
13. | 870.963 | 870.963 | ↓ 8.0 | 1,928 | 123 |
→
CTE Scan on cu cu_1 (cost=0.00..1,086.62 rows=241 width=532) (actual time=0.002..7.081 rows=1,928 loops=123)
|