# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 8,440.610 | 170,350.214 | ↓ 44,759.3 | 134,278 | 1 |
→
GroupAggregate (cost=1,217,029.07..1,234,070.93 rows=3 width=111) (actual time=140,442.025..170,350.214 rows=134,278 loops=1)
|
2. | 5,869.336 | 161,909.604 | ↓ 135.1 | 42,962,516 | 1 |
→
Merge Left Join (cost=1,217,029.07..1,219,413.53 rows=317,925 width=658) (actual time=140,442.012..161,909.604 rows=42,962,516 loops=1)
|
3. | 138,645.319 | 156,040.252 | ↓ 135.1 | 42,962,516 | 1 |
→
Sort (cost=1,217,026.84..1,217,821.66 rows=317,925 width=134) (actual time=140,441.990..156,040.252 rows=42,962,516 loops=1)
|
4. | 12,437.459 | 17,394.933 | ↓ 135.1 | 42,962,516 | 1 |
→
Hash Right Join (cost=32,228.06..1,187,971.16 rows=317,925 width=134) (actual time=309.920..17,394.933 rows=42,962,516 loops=1)
|
5. | 4,647.788 | 4,647.788 | ↓ 1.0 | 4,567,041 | 1 |
→
Seq Scan on pr_sys_appcache_shortcut ac_shortcut (cost=0.00..1,101,190.02 rows=4,566,562 width=130) (actual time=0.028..4,647.788 rows=4,567,041 loops=1)
|
6. | 47.051 | 309.686 | ↑ 1.0 | 155,525 | 1 |
→
Hash (cost=29,482.49..29,482.49 rows=156,890 width=119) (actual time=309.686..309.686 rows=155,525 loops=1)
|
7. | 47.726 | 262.635 | ↑ 1.0 | 155,525 | 1 |
→
Hash Right Join (cost=23,217.60..29,482.49 rows=156,890 width=119) (actual time=191.199..262.635 rows=155,525 loops=1)
|
8. | 23.935 | 23.935 | ↑ 1.0 | 20,184 | 1 |
→
Seq Scan on pr4_log_rule_usage usage (cost=0.00..6,098.84 rows=20,184 width=113) (actual time=0.008..23.935 rows=20,184 loops=1) |
9. | 46.917 | 190.974 | ↑ 1.1 | 139,907 | 1 |
→
Hash (cost=20,864.26..20,864.26 rows=156,890 width=111) (actual time=190.974..190.974 rows=139,907 loops=1)
|
10. | 144.057 | 144.057 | ↑ 1.1 | 139,907 | 1 |
→
Seq Scan on pr_assembledclasses asm (cost=0.00..20,864.26 rows=156,890 width=111) (actual time=0.020..144.057 rows=139,907 loops=1)
|
11. | 0.007 | 0.016 | ↓ 0.0 | 0 | 1 |
→
Sort (cost=2.23..2.23 rows=1 width=1,702) (actual time=0.016..0.016 rows=0 loops=1)
|
12. | 0.009 | 0.009 | ↓ 0.0 | 0 | 1 |
→
Index Scan using cache_entry_rule on pr_sys_cache_entry ra_entry (cost=0.14..2.22 rows=1 width=1,702) (actual time=0.009..0.009 rows=0 loops=1)
|