# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.003 | 10.111 | ↑ 1.0 | 1 | 1 |
→
Aggregate (cost=224.70..224.71 rows=1 width=6) (actual time=10.111..10.111 rows=1 loops=1) |
2. | 0.004 | 10.108 | ↓ 0.0 | 0 | 1 |
→
Nested Loop (cost=0.70..224.69 rows=1 width=6) (actual time=10.108..10.108 rows=0 loops=1)
|
3. | 0.007 | 3.984 | ↑ 1.0 | 1 | 1 |
→
Nested Loop (cost=0.70..16.76 rows=1 width=18) (actual time=2.463..3.984 rows=1 loops=1) |
4. | 3.648 | 3.648 | ↑ 1.0 | 1 | 1 |
→
Index Scan using conceptoutcomedetail_idx on cb_hr_conceptoutcomedetail con (cost=0.42..8.45 rows=1 width=12) (actual time=2.130..3.648 rows=1 loops=1)
|
5. | 0.329 | 0.329 | ↑ 1.0 | 1 | 1 |
→
Index Scan using cb_hr_earningcodes_pkey on cb_hr_earningcodes ed (cost=0.28..8.30 rows=1 width=6) (actual time=0.328..0.329 rows=1 loops=1)
|
6. | 6.120 | 6.120 | ↓ 0.0 | 0 | 1 |
→
Seq Scan on cb_hr_earningcodes_taxcfg td (cost=0.00..207.92 rows=1 width=7) (actual time=6.120..6.120 rows=0 loops=1)
|
Planning time | : | 6.096 ms |
---|---|---|
Execution time | : | 10.225 ms |