Search Postgresql Archives

Re: possible bug

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





So what happens if query the table directly?:

select * from wf.workflow  where head_table_id::float8::int8 = 25408438504;

vs

select * from wf.workflow  where head_table_id = 25408438504;


Both return lots of rows. The same number of rows.

select count(*) from wf.workflow  where head_table_id::float8::int8 = 25408438504;
count|
-----+
62260|

select count(*) from wf.workflow  where head_table_id = 25408438504;
count|
-----+
62260|

Both of them use seq scan.

QUERY PLAN                                                         |
-------------------------------------------------------------------+
Aggregate  (cost=2985.00..2985.01 rows=1 width=8)                  |
  ->  Seq Scan on workflow  (cost=0.00..2829.07 rows=62369 width=0)|
        Filter: (head_table_id = '25408438504'::bigint)            |

QUERY PLAN                                                                           |
-------------------------------------------------------------------------------------+
Aggregate  (cost=3289.86..3289.87 rows=1 width=8)                                    |
  ->  Seq Scan on workflow  (cost=0.00..3288.70 rows=460 width=0)                    |
        Filter: (((head_table_id)::double precision)::bigint = '25408438504'::bigint)|
 

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux