Re: Sequential scan where Index scan expected (update)

Andrew Sullivan wrote:
>> thing_event_id=10000;
>>
> ^^^^^
>
> in quotes. The automatic int4-int8 coercion is probably your
> problem. Also
>
Yup that's it. But this project uses (ugh) Hibernate. I can't change
it. I may have to change
from BIGINT primary keys to INT.

Also:
Any hints on the table statistics? I turn them on, in a session, as
user postgres, but get nothing:

stage=# SHOW ALL;
name | setting
--------------------------------+----------------
...
stats_block_level | on
stats_command_string | on
stats_reset_on_server_start | on
stats_row_level | on
stats_start_collector | on

stage=# select * from pg_statio_user_indexes;
relid | indexrelid | schemaname | relname
| indexrelname | idx_blks_read | idx_blks_hit
----------+------------+------------+-----------------------------+----------------------------------+---------------+--------------
18810975 | 18811183 | public | eg_invoice |
ix22f7bc70c7de2059 | 0 | 0
18810979 | 18811184 | public | eg_order |
ix522779518edf278d | 0 | 0
18810984 | 18811185 | public | eg_invoice_tax |
ix2f10773c8edf278d | 0 | 0
18810986 | 18811186 | public | eg_order_line |
ixf8331222783867cc | 0 | 0