Public feed
#724554
---------------------------------------------------------------------------------------------------------------------------------------
Hash IN Join (cost=63.66..1463.95 rows=19090 width=30) (actual time=8.552..92.186 rows=18982 loops=1)
Hash Cond: (fvordercase.orderid = fvorder.id)
-> Seq Scan on fvordercase (cost=0.00..1025.19 rows=49119 width=34) (actual time=0.028..35.515 rows=49035 loops=1)
-> Hash (cost=51.51..51.51 rows=972 width=4) (actual time=6.147..6.147 rows=948 loops=1)
-> Index Scan using fvorder_idx1 on fvorder (cost=0.00..51.51 rows=972 width=4) (actual time=0.098..5.167 rows=948 loops=1)
Index Cond: (creationdate > (('now'::text)::date - '65 days'::interval))
Total runtime: 101.310 ms
(7 rows)
scaledb=# explain analyze SELECT barcode FROM fvordercase WHERE orderid IN (SELECT id FROM fvorder WHERE creationdate > CURRENT_DATE - interval '60 days');
QUERY PLAN
---------------------------------------------------------------------------------------------------------------------------------------
Hash IN Join (cost=55.65..1435.90 rows=17087 width=30) (actual time=4.888..90.537 rows=16986 loops=1)
Hash Cond: (fvordercase.orderid = fvorder.id)
-> Seq Scan on fvordercase (cost=0.00..1025.19 rows=49119 width=34) (actual time=0.031..37.390 rows=49035 loops=1)
-> Hash (cost=44.77..44.77 rows=870 width=4) (actual time=2.351..2.351 rows=851 loops=1)
-> Index Scan using fvorder_idx1 on fvorder (cost=0.00..44.77 rows=870 width=4) (actual time=0.065..1.441 rows=851 loops=1)
Index Cond: (creationdate > (('now'::text)::date - '60 days'::interval))
Total runtime: 98.710 ms
(7 rows)