Huge delay to finish even having all the records inserted

[Alexander Franca Fernandes <affedem@xxxxxxxxx>]

Hi,

I'm inserting 14 millions records from a text file using the Postgre COPY command.

After waiting five days I've realized that all the records seems to be already inserted,

but the process is still running!!

I don't know if there's any internal postgresql process that impose that I have to wait even having the records shown in a SELECT query...

I don't know if it's safe to cancel the process right now.

Here's the activity query result (I've cut the columns into lines):

postgres=# SELECT * from pg_stat_activity ;


 datid  |
--------+
 136776 |
-----------------
 datname  |
----------+
 xyzdb    |

-----------------
 procpid |
---------+-
  303311 |

-----------------
usesysid |
---------+-
   16387 |

-----------------
usename  |
---------+
xyz      |

-----------------

          current_query           |      
----------------------------------+-
 <IDLE>                           |

--------------------------------------

waiting |
--------+
f       |      

-----------------
          xact_start           |
-------------------------------+
                               |      

-----------------------------------------------------------
          query_start          |      
-------------------------------+
 2015-12-18 12:01:05.553534-06 |

-----------------------------------------------------------
         backend_start         | client_addr | client_port
-------------------------------+-------------+-------------
 2015-12-18 12:01:05.547759-06 |             |          -1     

[]s

Alex