Sort (actual time=889.261..889.566 rows=3128 loops=1)
Output: b.sale_date, b.sale_id, b.employee_id, b.eur_value |
Sort Key: b.sale_date |
Sort Method: quicksort Memory: 341kB |
Buffers: shared hit=16184 read=19076 |
-> Nested Loop (actual time=872.391..888.349 rows=3128 loops=1)
Output: b.sale_date, b.sale_id, b.employee_id, b.eur_value |
Inner Unique: true |
Buffers: shared hit=16184 read=19076 |
-> HashAggregate (actual time=872.374..873.590 rows=3128 loops=1)
Output: sales.sale_date, (max(ARRAY[sales.eur_value, sales.sale_id]))[2]
Group Key: sales.sale_date |
Batches: 1 Memory Usage: 625kB |
Buffers: shared hit=3672 read=19076 |
-> Seq Scan on portal.sales (actual time=0.077..197.715 rows=2206461 loops=1)
Output: sales.sale_id, sales.employee_id, sales.subsidiary_id, sales.sale_date, sales.eur_value, sales.product_id, sales.quantity, sales.channel |
Buffers: shared hit=3672 read=19076 |
-> Index Scan using sales_pk on portal.sales b (actual time=0.004..0.004 rows=1 loops=3128)
Output: b.sale_id, b.employee_id, b.subsidiary_id, b.sale_date, b.eur_value, b.product_id, b.quantity, b.channel
Index Cond: (b.sale_id = ((max(ARRAY[sales.eur_value, sales.sale_id]))[2]))
Buffers: shared hit=12512 |
Planning Time: 0.113 ms |
Execution Time: 889.726 ms