# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.625 | 557.567 | ↓ 1.0 | 753 | 1 |
→
Sort (cost=8,245.75..8,247.62 rows=750 width=99) (actual time=557.483..557.567 rows=753 loops=1)
|
2. | 221.894 | 556.942 | ↓ 1.0 | 753 | 1 |
→
HashAggregate (cost=8,202.43..8,209.93 rows=750 width=99) (actual time=556.738..556.942 rows=753 loops=1)
|
3. | 210.183 | 335.048 | ↓ 10.3 | 890,723 | 1 |
→
Hash Join (cost=6,006.98..7,770.48 rows=86,390 width=95) (actual time=105.938..335.048 rows=890,723 loops=1)
|
4. | 14.526 | 120.654 | ↓ 2.0 | 32,633 | 1 |
→
Hash Join (cost=5,901.77..6,658.63 rows=16,316 width=8) (actual time=101.701..120.654 rows=32,633 loops=1)
|
5. | 4.600 | 4.600 | ↑ 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.018..4.600 rows=32,633 loops=1) |
6. | 9.394 | 101.528 | ↓ 2.0 | 24,491 | 1 |
→
Hash (cost=5,748.69..5,748.69 rows=12,246 width=8) (actual time=101.528..101.528 rows=24,491 loops=1)
|
7. | 28.862 | 92.134 | ↓ 2.0 | 24,491 | 1 |
→
Hash Join (cost=1,336.75..5,748.69 rows=12,246 width=8) (actual time=40.041..92.134 rows=24,491 loops=1)
|
8. | 23.517 | 23.517 | ↑ 1.0 | 24,492 | 1 |
→
Seq Scan on post (cost=0.00..4,078.92 rows=24,492 width=4) (actual time=0.022..23.517 rows=24,492 loops=1) |
9. | 7.085 | 39.755 | ↓ 1.0 | 24,491 | 1 |
→
Hash (cost=1,035.27..1,035.27 rows=24,118 width=4) (actual time=39.755..39.755 rows=24,491 loops=1)
|
10. | 4.644 | 32.670 | ↓ 1.0 | 24,491 | 1 |
→
Subquery Scan on a (cost=552.91..1,035.27 rows=24,118 width=4) (actual time=21.483..32.670 rows=24,491 loops=1) |
11. | 21.318 | 28.026 | ↓ 1.0 | 24,491 | 1 |
→
HashAggregate (cost=552.91..794.09 rows=24,118 width=36) (actual time=21.482..28.026 rows=24,491 loops=1)
|
12. | 6.708 | 6.708 | ↑ 1.0 | 32,633 | 1 |
→
Seq Scan on post_to_tag_link (cost=0.00..471.33 rows=32,633 width=4) (actual time=0.015..6.708 rows=32,633 loops=1) |
13. | 0.848 | 4.211 | ↓ 1.1 | 1,318 | 1 |
→
Hash (cost=90.39..90.39 rows=1,186 width=99) (actual time=4.211..4.211 rows=1,318 loops=1)
|
14. | 0.728 | 3.363 | ↓ 1.1 | 1,318 | 1 |
→
Hash Join (cost=39.91..90.39 rows=1,186 width=99) (actual time=1.446..3.363 rows=1,318 loops=1)
|
15. | 0.862 | 2.300 | ↓ 1.1 | 1,318 | 1 |
→
Hash Join (cost=29.88..64.04 rows=1,186 width=95) (actual time=1.085..2.300 rows=1,318 loops=1)
|
16. | 0.422 | 0.422 | ↓ 1.1 | 1,318 | 1 |
→
Seq Scan on card_to_tag_link card_to_tag_link_1 (cost=0.00..17.86 rows=1,186 width=8) (actual time=0.042..0.422 rows=1,318 loops=1) |
17. | 0.486 | 1.016 | ↓ 1.0 | 757 | 1 |
→
Hash (cost=20.50..20.50 rows=750 width=91) (actual time=1.016..1.016 rows=757 loops=1)
|
18. | 0.530 | 0.530 | ↓ 1.0 | 757 | 1 |
→
Seq Scan on card (cost=0.00..20.50 rows=750 width=91) (actual time=0.023..0.530 rows=757 loops=1) |
19. | 0.103 | 0.335 | ↑ 1.0 | 224 | 1 |
→
Hash (cost=7.24..7.24 rows=224 width=4) (actual time=0.335..0.335 rows=224 loops=1)
|
20. | 0.232 | 0.232 | ↑ 1.0 | 224 | 1 |
→
Seq Scan on tag (cost=0.00..7.24 rows=224 width=4) (actual time=0.016..0.232 rows=224 loops=1) |