# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.003 | 151,950.872 | ↓ 0.0 | 0 | 1 |
→
Limit (cost=77,589.10..77,589.34 rows=95 width=1,104) (actual time=151,950.872..151,950.872 rows=0 loops=1) |
2. | 0.063 | 151,950.869 | ↓ 0.0 | 0 | 1 |
→
Sort (cost=77,589.10..77,589.34 rows=95 width=1,104) (actual time=151,950.869..151,950.869 rows=0 loops=1)
|
3. | 1.523 | 151,950.806 | ↓ 0.0 | 0 | 1 |
→
Hash Join (cost=12,715.66..77,585.98 rows=95 width=1,104) (actual time=151,950.806..151,950.806 rows=0 loops=1)
|
4. | 687.905 | 771.981 | ↑ 32.2 | 583 | 1 |
→
Bitmap Heap Scan on tbl_contact_interaction call (cost=1,450.45..66,083.65 rows=18,782 width=1,104) (actual time=98.047..771.981 rows=583 loops=1)
|
5. | 84.076 | 84.076 | ↑ 33.2 | 583 | 1 |
→
Bitmap Index Scan on idx_contact_int_project (cost=0.00..1,445.75 rows=19,359 width=0) (actual time=84.076..84.076 rows=583 loops=1)
|
6. | 94.871 | 151,177.302 | ↓ 1.0 | 60,370 | 1 |
→
Hash (cost=10,540.93..10,540.93 rows=57,942 width=8) (actual time=151,177.302..151,177.302 rows=60,370 loops=1)
|
7. | 151,082.431 | 151,082.431 | ↓ 1.0 | 60,370 | 1 |
→
Index Scan using idx_call_listening_state on tbl_phone_call_qmparam params (cost=0.56..10,540.93 rows=57,942 width=8) (actual time=31.252..151,082.431 rows=60,370 loops=1)
|
Planning time | : | 293.576 ms |
---|---|---|
Execution time | : | 151,951.665 ms |