Re: [SQL] Sequential scan where Index scan expected (update)

[Bryce Nesbitt]

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