Here they are :
EXPLAIN
(SELECT e.name
FROM Observation o, Exposure_EPIC e
WHERE o.numObs = e.obs
AND e.instrPN IS NOT NULL
AND o.RA BETWEEN 3 AND 5);
NOTICE: QUERY PLAN:
Hash Join (cost=25.02..60.98 rows=33 width=20)
-> Seq Scan on exposure_epic e (cost=0.00..22.50 rows=333 width=16)
-> Hash (cost=25.00..25.00 rows=10 width=4)
-> Seq Scan on observation o (cost=0.00..25.00 rows=10
width=4)
EXPLAIN
----------------------------------------------------
EXPLAIN
(SELECT e.name
FROM Observation o, Exposure_EPIC e
WHERE o.numObs = e.obs
AND e.instrPN IS NOT NULL
AND o.DE BETWEEN 2 AND 7);
NOTICE: QUERY PLAN:
Hash Join (cost=25.02..60.98 rows=33 width=20)
-> Seq Scan on exposure_epic e (cost=0.00..22.50 rows=333 width=16)
-> Hash (cost=25.00..25.00 rows=10 width=4)
-> Seq Scan on observation o (cost=0.00..25.00 rows=10
width=4)
EXPLAIN
---------------------------------------------------
EXPLAIN
(SELECT e.name
FROM Observation o, Exposure_EPIC e
WHERE o.numObs = e.obs
AND e.instrPN IS NOT NULL
AND o.RA BETWEEN 3 AND 5
AND o.DE BETWEEN 2 AND 7);
NOTICE: QUERY PLAN:
Nested Loop (cost=0.00..56.67 rows=3 width=20)
-> Seq Scan on observation o (cost=0.00..30.00 rows=1 width=4)
-> Seq Scan on exposure_epic e (cost=0.00..22.50 rows=333 width=16)
EXPLAIN
--------------------------------------------------
Table Observation has 5000 rows and 10 columns
Table Exposure_Epic has 45000 rows and 6 columns
I haven't create any index
If use ---> >2 and <7 , this is the same result.
Thank you for your help
Renaud THONNART
