query-plan-1238
Change label- Query Plan as raw text
-
- Summary
-
Time Node Node (ms) Percent 7244.475 100.00% ¶ Aggregate (cost=32.31..32.32 rows=1 width=4) (actual time=7244.475..7244.475 rows=1 loops=1)7243.000 99.98% ¶ -> Nested Loop Left Join (cost=0.0..17.11 rows=3040 width=4) (actual time=0.158..7243.000 rows=2953 loops=1)0.081 0.00% ¶ -> Index Scan using cellid on cell15 (cost=0.0..8.27 rows=1 width=4) (actual time=0.079..0.081 rows=1 loops=1) Index Cond: (id = 10)7240.947 99.95% ¶ -> Index Scan using ne_id_idx on stscell15 (cost=0.0..8.83 rows=1 width=8) (actual time=0.072..7240.947 rows=2953 loops=1) Index Cond: ((stscell15.ne_id = 10) AND (cell15.id = stscell15.ne_id)) - Run-time
- 7.244651 seconds (7244.651 ms)

ANALYZEto update the server's statistics.EXPLAINand interpreting its output, see the Postgres documentation, in particular theEXPLAINandANALYZEreferences pages, and Using Explain.