# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.016 | 7,348.110 | ↑ 1.0 | 100 | 1 |
→
Limit (cost=273,701.59..273,713.26 rows=100 width=809) (actual time=7,342.684..7,348.110 rows=100 loops=1)
|
2. | 0.000 | 7,348.094 | ↑ 91,746.4 | 100 | 1 |
→
Gather Merge (cost=273,701.59..1,344,150.99 rows=9,174,640 width=809) (actual time=7,342.682..7,348.094 rows=100 loops=1)
|
3. | 3,891.714 | 21,862.332 | ↑ 45,873.2 | 100 | 3 |
→
Sort (cost=272,701.57..284,169.87 rows=4,587,320 width=809) (actual time=7,287.438..7,287.444 rows=100 loops=3)
|
4. | 2,891.211 | 17,970.618 | ↑ 1.4 | 3,333,330 | 3 |
→
Hash Left Join (cost=308.07..97,377.50 rows=4,587,320 width=809) (actual time=267.920..5,990.206 rows=3,333,330 loops=3)
|
5. | 516.591 | 14,688.456 | ↑ 1.4 | 333,333 | 3 |
→
Hash Join (cost=28.07..44,325.43 rows=459,926 width=457) (actual time=137.494..4,896.152 rows=333,333 loops=3)
|
6. | 14,111.262 | 14,111.262 | ↑ 1.4 | 333,333 | 3 |
→
Parallel Index Scan using pgbench_accounts_pkey on public.pgbench_accounts (cost=0.57..43,085.50 rows=459,926 width=97) (actual time=117.167..4,703.754 rows=333,333 loops=3)
|
7. | 0.618 | 60.603 | ↑ 1.0 | 1,000 | 3 |
→
Hash (cost=15.00..15.00 rows=1,000 width=364) (actual time=20.200..20.201 rows=1,000 loops=3)
|
8. | 59.985 | 59.985 | ↑ 1.0 | 1,000 | 3 |
→
Seq Scan on public.pgbench_branches (cost=0.00..15.00 rows=1,000 width=364) (actual time=13.090..19.995 rows=1,000 loops=3)
|
9. | 5.811 | 390.951 | ↑ 1.0 | 10,000 | 3 |
→
Hash (cost=155.00..155.00 rows=10,000 width=352) (actual time=130.317..130.317 rows=10,000 loops=3)
|
10. | 385.140 | 385.140 | ↑ 1.0 | 10,000 | 3 |
→
Seq Scan on public.pgbench_tellers (cost=0.00..155.00 rows=10,000 width=352) (actual time=16.691..128.380 rows=10,000 loops=3)
|