Thank you replay!
I tried to use the TMP table is very fast .thank you
qis3_dp2=# explain analyze SELECT COUNT(*),SMTOC FROM ( SELECT
DISTINCT(SVIN) AS CHECKCARNUM,SMTOC FROM QIS_CARPASSEDSTATION A WHERE 1=1
AND A.SSTATIONCD = 'VQ3_LYG' AND A.SLINENO IN ( '1F' , '2F' , '3F' ) AND
A.DWORKDAT
1、DISTINCT response time is fast without being added
qis3_dp2=# SELECT COUNT(*) AS CHECKCARNUM FROM QIS_CARPASSEDSTATION A WHERE
1=1 AND A.SSTATIONCD = 'VQ3_LYG' AND A.SLINENO IN ( '1F' , '2F' , '3F' ) AND
A.DWORKDATE >= TO_DATE('2017-02-11','-MM-DD') AND A.DWORKDATE <=
TO_DATE('2019-03-11','
Thank you for your reply.
qis3_dp2=> SHOW lc_collate;
lc_collate
-
en_US.UTF-8
(1 row)
Time: 0.311 ms
qis3_dp2=>
qis3_dp2=> SELECT COUNT(DISTINCT SVIN) AS CHECKCARNUM ,SMTOC FROM
QIS_CARPASSEDSTATION A WHERE 1=1 AND A.SSTATIONCD = 'VQ3_LYG' AND
A.SLINYYY-MM-DD') AND A.DWORKDAT
1、postgresql version
qis3_dp2=> select * from version();
version
-
PostgreSQL 11.1 on x86_64-p
