explain-analyze.info | query-plan-1170

Summary

Time Node

Node (ms) Percent

Time	Node
Node (ms)	Percent
7259.170	100.00%	¶	`Sort (cost=182934.14..186231.14 rows=1318799 width=207) (actual time=6349.991..7259.170 rows=1316838 loops=1) Sort Key: id Sort Method: quicksort Memory: 406008kB`
3771.602	51.96%	¶	`-> Seq Scan on kor (cost=0.0..48872.99 rows=1318799 width=207) (actual time=0.019..3771.602 rows=1316838 loops=1)`

7259.170

100.00%

 Sort (cost=182934.14..186231.14 rows=1318799 width=207) (actual time=6349.991..7259.170 rows=1316838 loops=1)
   Sort Key: id
   Sort Method:  quicksort  Memory: 406008kB

3771.602

51.96%

   -> Seq Scan on kor (cost=0.0..48872.99 rows=1318799 width=207) (actual time=0.019..3771.602 rows=1316838 loops=1)

Run-time

7.997555 seconds (7997.555 ms)

Highlighted rows indicate a disparity between the number of rows estimated and actually returned. You may want to run ANALYZE to update the server's statistics.
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.