> explain select count(*) from sq_logfile;
Not too helpful.
Better choice is:
explain analyze select * from sq_logfile;
Your explains show that selecting from view is 4 times slower than
selecting from a table (35988:128282). It is possible.
Anyway counting 1 million rows usualy takes a long time...
Regards,
Tomasz Myrta