# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.001 | 1,846.315 | ↑ 1.0 | 24 | 1 |
→
Limit (cost=101,792.64..101,792.70 rows=24 width=227) (actual time=1,846.313..1,846.315 rows=24 loops=1) |
2. | 6.844 | 1,846.314 | ↑ 927.3 | 24 | 1 |
→
Sort (cost=101,792.64..101,848.28 rows=22,255 width=227) (actual time=1,846.313..1,846.314 rows=24 loops=1)
|
3. | 3.592 | 1,839.470 | ↑ 1.0 | 21,821 | 1 |
→
Subquery Scan on cc (cost=99,791.34..101,171.17 rows=22,255 width=227) (actual time=1,790.004..1,839.470 rows=21,821 loops=1) |
4. | 21.448 | 1,835.878 | ↑ 1.0 | 21,821 | 1 |
→
Unique (cost=99,791.34..100,948.62 rows=22,255 width=235) (actual time=1,790.002..1,835.878 rows=21,821 loops=1) |
5. | 1,241.841 | 1,814.430 | ↓ 1.1 | 245,113 | 1 |
→
Sort (cost=99,791.34..100,369.98 rows=231,457 width=235) (actual time=1,790.001..1,814.430 rows=245,113 loops=1)
|
6. | 261.846 | 572.589 | ↓ 1.1 | 245,113 | 1 |
→
Hash Right Join (cost=11,809.88..79,168.07 rows=231,457 width=235) (actual time=116.802..572.589 rows=245,113 loops=1)
|
7. | 34.373 | 236.348 | ↑ 1.0 | 967,975 | 1 |
→
Append (cost=0.00..52,933.27 rows=968,828 width=109) (actual time=0.004..236.348 rows=967,975 loops=1) |
8. | 0.000 | 0.000 | ↓ 0.0 | 0 | 1 |
→
Seq Scan on videoexporthistory_v2 bb (cost=0.00..0.00 rows=1 width=108) (actual time=0.000..0.000 rows=0 loops=1) |
9. | 201.975 | 201.975 | ↑ 1.0 | 967,975 | 1 |
→
Seq Scan on videoexporthistory_v2_0 bb_1 (cost=0.00..52,933.27 rows=968,827 width=109) (actual time=0.003..201.975 rows=967,975 loops=1) |
10. | 11.697 | 74.395 | ↑ 1.0 | 33,172 | 1 |
→
Hash (cost=11,375.84..11,375.84 rows=34,723 width=167) (actual time=74.395..74.395 rows=33,172 loops=1)
|
11. | 41.389 | 62.698 | ↑ 1.0 | 33,172 | 1 |
→
Hash Right Join (cost=4,135.51..11,375.84 rows=34,723 width=167) (actual time=46.922..62.698 rows=33,172 loops=1)
|
12. | 12.409 | 12.409 | ↑ 1.0 | 226,779 | 1 |
→
Seq Scan on salestransactionpayment (cost=0.00..4,908.79 rows=226,779 width=49) (actual time=0.007..12.409 rows=226,779 loops=1) |
13. | 4.488 | 8.900 | ↑ 1.0 | 21,821 | 1 |
→
Hash (cost=3,857.33..3,857.33 rows=22,254 width=160) (actual time=8.900..8.900 rows=21,821 loops=1)
|
14. | 3.192 | 4.412 | ↑ 1.0 | 21,821 | 1 |
→
Bitmap Heap Scan on salestransaction aa (cost=476.52..3,857.33 rows=22,254 width=160) (actual time=1.362..4.412 rows=21,821 loops=1)
|
15. | 1.220 | 1.220 | ↑ 1.0 | 21,821 | 1 |
→
Bitmap Index Scan on salestransaction_startactiondate_ix (cost=0.00..470.96 rows=22,254 width=0) (actual time=1.220..1.220 rows=21,821 loops=1)
|
Planning time | : | 0.592 ms |
---|---|---|
Execution time | : | 1,860.623 ms |