# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.074 | 18,539.810 | ↓ 50.0 | 100 | 1 |
→
Limit (cost=0.00..5.00 rows=2 width=46) (actual time=1,665.204..18,539.810 rows=100 loops=1) |
2. | 10,242.089 | 18,539.736 | ↓ 50.0 | 100 | 1 |
→
Nested Loop (cost=0.00..5.00 rows=2 width=46) (actual time=1,665.202..18,539.736 rows=100 loops=1)
|
3. | 0.116 | 2.152 | ↓ 123.5 | 247 | 1 |
→
Append (cost=0.00..2.40 rows=2 width=12) (actual time=0.077..2.152 rows=247 loops=1) |
4. | 0.004 | 0.004 | ↓ 0.0 | 0 | 1 |
→
Seq Scan on customer (cost=0.00..0.00 rows=1 width=12) (actual time=0.004..0.004 rows=0 loops=1)
|
5. | 2.032 | 2.032 | ↓ 247.0 | 247 | 1 |
→
Index Scan using data_customer_2019_11_cutoff_date_identifier_key on data_customer_2019_11 (cost=0.57..2.40 rows=1 width=12) (actual time=0.072..2.032 rows=247 loops=1)
|
6. | 6,901.847 | 8,295.495 | ↓ 527,907.5 | 1,055,815 | 247 |
→
Materialize (cost=0.00..2.53 rows=2 width=46) (actual time=2.701..33.585 rows=1,055,815 loops=247) |
7. | 40.525 | 1,393.648 | ↓ 529,764.0 | 1,059,528 | 1 |
→
Append (cost=0.00..2.52 rows=2 width=46) (actual time=667.180..1,393.648 rows=1,059,528 loops=1) |
8. | 0.002 | 0.002 | ↓ 0.0 | 0 | 1 |
→
Seq Scan on account (cost=0.00..0.00 rows=1 width=60) (actual time=0.002..0.002 rows=0 loops=1)
|
9. | 1,353.121 | 1,353.121 | ↓ 1,059,528.0 | 1,059,528 | 1 |
→
Index Scan using data_account_2019_11_cutoff_date_idx on data_account_2019_11 (cost=0.57..2.52 rows=1 width=32) (actual time=667.177..1,353.121 rows=1,059,528 loops=1)
|
Planning time | : | 35.012 ms |
---|---|---|
Execution time | : | 18,553.259 ms |