# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.678 | 516.856 | ↑ 1.0 | 753 | 1 |
→
Sort (cost=8,667.12..8,669.01 rows=757 width=99) (actual time=516.763..516.856 rows=753 loops=1)
|
2. | 241.230 | 516.178 | ↑ 1.0 | 753 | 1 |
→
HashAggregate (cost=8,623.35..8,630.92 rows=757 width=99) (actual time=515.895..516.178 rows=753 loops=1)
|
3. | 224.151 | 274.948 | ↓ 4.6 | 890,723 | 1 |
→
Hash Join (cost=4,496.83..7,663.30 rows=192,010 width=95) (actual time=26.920..274.948 rows=890,723 loops=1)
|
4. | 19.062 | 47.061 | ↑ 1.0 | 32,633 | 1 |
→
Hash Join (cost=4,385.07..5,305.10 rows=32,633 width=8) (actual time=23.136..47.061 rows=32,633 loops=1)
|
5. | 5.177 | 5.177 | ↑ 1.0 | 32,633 | 1 |
→
Seq Scan on post_to_tag_link post_to_tag_link_1 (cost=0.00..471.33 rows=32,633 width=8) (actual time=0.022..5.177 rows=32,633 loops=1) |
6. | 9.217 | 22.822 | ↑ 1.0 | 24,492 | 1 |
→
Hash (cost=4,078.92..4,078.92 rows=24,492 width=4) (actual time=22.822..22.822 rows=24,492 loops=1)
|
7. | 13.605 | 13.605 | ↑ 1.0 | 24,492 | 1 |
→
Seq Scan on post (cost=0.00..4,078.92 rows=24,492 width=4) (actual time=0.011..13.605 rows=24,492 loops=1) |
8. | 0.848 | 3.736 | ↑ 1.0 | 1,318 | 1 |
→
Hash (cost=95.29..95.29 rows=1,318 width=99) (actual time=3.735..3.736 rows=1,318 loops=1)
|
9. | 0.748 | 2.888 | ↑ 1.0 | 1,318 | 1 |
→
Hash Join (cost=40.07..95.29 rows=1,318 width=99) (actual time=1.041..2.888 rows=1,318 loops=1)
|
10. | 0.875 | 1.962 | ↑ 1.0 | 1,318 | 1 |
→
Hash Join (cost=30.03..67.12 rows=1,318 width=95) (actual time=0.840..1.962 rows=1,318 loops=1)
|
11. | 0.294 | 0.294 | ↑ 1.0 | 1,318 | 1 |
→
Seq Scan on card_to_tag_link card_to_tag_link_1 (cost=0.00..19.18 rows=1,318 width=8) (actual time=0.015..0.294 rows=1,318 loops=1) |
12. | 0.480 | 0.793 | ↑ 1.0 | 757 | 1 |
→
Hash (cost=20.57..20.57 rows=757 width=91) (actual time=0.793..0.793 rows=757 loops=1)
|
13. | 0.313 | 0.313 | ↑ 1.0 | 757 | 1 |
→
Seq Scan on card (cost=0.00..20.57 rows=757 width=91) (actual time=0.012..0.313 rows=757 loops=1) |
14. | 0.098 | 0.178 | ↑ 1.0 | 224 | 1 |
→
Hash (cost=7.24..7.24 rows=224 width=4) (actual time=0.178..0.178 rows=224 loops=1)
|
15. | 0.080 | 0.080 | ↑ 1.0 | 224 | 1 |
→
Seq Scan on tag (cost=0.00..7.24 rows=224 width=4) (actual time=0.015..0.080 rows=224 loops=1) |