explain-analyze.info | query-plan-1157

Summary: Nested Loop (cost=0.00..16913.30 rows=897 width=78) -> Index Scan using journal_small_typename on journal_small j (cost=0.00..1265.38 rows=326 width=21) Index Cond: ((typename)::text = '報表'::text) -> Index Scan using dissection_small_journal on dissection_small d (cost=0.00..47.86 rows=11 width=78) Index Cond: ((d.journal)::text = (j.primaryid)::text)

To check the planner's accuracy, run [EXPLAIN ANALYZE].
For more information on using EXPLAIN and interpreting its output, see the Postgres documentation, in particular the EXPLAIN and ANALYZE references pages, and Using Explain.