Programming, Alibaba Cloud, Database, Postgresql, Data Analytics.
where t.* is not null group by 1; INSERT 0 2 Time: 12.061 ms postgres=# select * from result ; crt_time | state | cnt ---------------------+-------+----- 2017-07-05 11:11:03 | f | 510 2017-07-05 11:11:03 | t | 491 (2 rows) Time: 0.274 ms It only takes 12 milliseconds per query, so there are no