# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 84.713 | 7,170.498 | ↓ 6.8 | 1,353 | 1 |
→
GroupAggregate (cost=378,770.36..404,079.89 rows=200 width=44) (actual time=6,556.081..7,170.498 rows=1,353 loops=1)
|
2. | 490.298 | 7,085.785 | ↓ 1.1 | 159,630 | 1 |
→
GroupAggregate (cost=378,770.36..399,610.62 rows=148,859 width=36) (actual time=6,555.938..7,085.785 rows=159,630 loops=1)
|
3. | 410.003 | 6,595.487 | ↓ 1.1 | 164,832 | 1 |
→
Sort (cost=378,770.36..379,142.51 rows=148,859 width=36) (actual time=6,555.857..6,595.487 rows=164,832 loops=1)
|
4. | 61.143 | 6,185.484 | ↓ 1.1 | 164,832 | 1 |
→
Nested Loop (cost=33,997.39..365,980.70 rows=148,859 width=36) (actual time=2,108.997..6,185.484 rows=164,832 loops=1)
|
5. | 72.686 | 5,645.313 | ↓ 1.1 | 159,676 | 1 |
→
Nested Loop (cost=33,996.96..295,313.10 rows=145,929 width=36) (actual time=2,108.394..5,645.313 rows=159,676 loops=1)
|
6. | 708.545 | 4,774.247 | ↓ 1.1 | 159,676 | 1 |
→
Hash Right Join (cost=33,996.53..178,813.76 rows=145,929 width=32) (actual time=2,107.169..4,774.247 rows=159,676 loops=1)
|
7. | 1,958.649 | 1,958.649 | ↓ 1.0 | 523,009 | 1 |
→
Seq Scan on order_status_event evtpyxis (cost=0.00..137,514.59 rows=518,566 width=12) (actual time=0.020..1,958.649 rows=523,009 loops=1)
|
8. | 2,107.053 | 2,107.053 | ↓ 1.1 | 159,676 | 1 |
→
Hash (cost=32,172.41..32,172.41 rows=145,929 width=24) (actual time=2,107.053..2,107.053 rows=159,676 loops=1)
|
9. | 798.380 | 798.380 | ↑ 1.0 | 1 | 159,676 |
→
Index Only Scan using project_pkey on project p (cost=0.43..0.79 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=159,676)
|
10. | 479.028 | 479.028 | ↑ 1.0 | 1 | 159,676 |
→
Index Scan using index_payment_project_id on payment pay (cost=0.43..0.47 rows=1 width=12) (actual time=0.002..0.003 rows=1 loops=159,676)
|