Right... on massive slow hardware (IO wise) takes 48 hours just to sync the basics (HAF slim alone)... NOT BAD AT ALL! (used to take more than 1 week on this hardware, a very long time ago), now I need the rest... but first snapshot :P

         table_name         |               index_constraint_name                | haf_status | phase | blocks_pct | tuples_pct | duration |     real_status
----------------------------+----------------------------------------------------+------------+-------+------------+------------+----------+---------------------
 hafd.account_operations    | account_operations_account_id_not_null             | created    |       |            |            |          | EXISTS (constraint)
 hafd.account_operations    | account_operations_account_id_not_null             | created    |       |            |            |          | EXISTS (constraint)
 hafd.account_operations    | account_operations_account_op_seq_no_not_null      | created    |       |            |            |          | EXISTS (constraint)
 hafd.account_operations    | account_operations_account_op_seq_no_not_null      | created    |       |            |            |          | EXISTS (constraint)
 hafd.account_operations    | account_operations_op_type_id_not_null             | created    |       |            |            |          | EXISTS (constraint)
 hafd.account_operations    | account_operations_op_type_id_not_null             | created    |       |            |            |          | EXISTS (constraint)
 hafd.account_operations    | account_operations_operation_id_not_null           | created    |       |            |            |          | EXISTS (constraint)
 hafd.account_operations    | account_operations_operation_id_not_null           | created    |       |            |            |          | EXISTS (constraint)
 hafd.account_operations    | account_operations_transacting_account_id_not_null | created    |       |            |            |          | EXISTS (constraint)
 hafd.account_operations    | account_operations_transacting_account_id_not_null | created    |       |            |            |          | EXISTS (constraint)
 hafd.account_operations    | hive_account_operations_account_id_op_type_id_idx  | created    |       |            |            |          | EXISTS
 hafd.account_operations    | hive_account_operations_fk_1                       | created    |       |            |            |          | EXISTS (constraint)
 hafd.account_operations    | hive_account_operations_fk_2                       | created    |       |            |            |          | EXISTS (constraint)
 hafd.account_operations    | hive_account_operations_fk_3                       | created    |       |            |            |          | EXISTS (constraint)
 hafd.account_operations    | hive_account_operations_uq1                        | created    |       |            |            |          | EXISTS
 hafd.accounts              | accounts_id_not_null                               | created    |       |            |            |          | EXISTS (constraint)
 hafd.accounts              | accounts_id_not_null                               | created    |       |            |            |          | EXISTS (constraint)
 hafd.accounts              | accounts_name_not_null                             | created    |       |            |            |          | EXISTS (constraint)
 hafd.accounts              | accounts_name_not_null                             | created    |       |            |            |          | EXISTS (constraint)
 hafd.accounts              | fk_1_hive_accounts                                 | created    |       |            |            |          | EXISTS (constraint)
 hafd.accounts              | hive_accounts_block_num_idx                        | created    |       |            |            |          | EXISTS
 hafd.accounts              | pk_hive_accounts_id                                | created    |       |            |            |          | EXISTS
 hafd.accounts              | uq_hive_accounst_name                              | created    |       |            |            |          | EXISTS
 hafd.applied_hardforks     | applied_hardforks_block_num_not_null               | created    |       |            |            |          | EXISTS (constraint)
 hafd.applied_hardforks     | applied_hardforks_block_num_not_null               | created    |       |            |            |          | EXISTS (constraint)
 hafd.applied_hardforks     | applied_hardforks_hardfork_num_not_null            | created    |       |            |            |          | EXISTS (constraint)
 hafd.applied_hardforks     | applied_hardforks_hardfork_num_not_null            | created    |       |            |            |          | EXISTS (constraint)
 hafd.applied_hardforks     | applied_hardforks_hardfork_vop_id_not_null         | created    |       |            |            |          | EXISTS (constraint)
 hafd.applied_hardforks     | applied_hardforks_hardfork_vop_id_not_null         | created    |       |            |            |          | EXISTS (constraint)
 hafd.applied_hardforks     | fk_1_hive_applied_hardforks                        | created    |       |            |            |          | EXISTS (constraint)
 hafd.applied_hardforks     | fk_2_hive_applied_hardforks                        | created    |       |            |            |          | EXISTS (constraint)
 hafd.applied_hardforks     | hive_applied_hardforks_block_num_idx               | created    |       |            |            |          | EXISTS
 hafd.applied_hardforks     | pk_hive_applied_hardforks                          | created    |       |            |            |          | EXISTS
 hafd.blocks                | blocks_created_at_not_null                         | created    |       |            |            |          | EXISTS (constraint)
 hafd.blocks                | blocks_created_at_not_null                         | created    |       |            |            |          | EXISTS (constraint)
 hafd.blocks                | blocks_hash_not_null                               | created    |       |            |            |          | EXISTS (constraint)
 hafd.blocks                | blocks_hash_not_null                               | created    |       |            |            |          | EXISTS (constraint)
 hafd.blocks                | blocks_num_not_null                                | created    |       |            |            |          | EXISTS (constraint)
 hafd.blocks                | blocks_num_not_null                                | created    |       |            |            |          | EXISTS (constraint)
 hafd.blocks                | blocks_prev_not_null                               | created    |       |            |            |          | EXISTS (constraint)
 hafd.blocks                | blocks_prev_not_null                               | created    |       |            |            |          | EXISTS (constraint)
 hafd.blocks                | blocks_producer_account_id_not_null                | created    |       |            |            |          | EXISTS (constraint)
 hafd.blocks                | blocks_producer_account_id_not_null                | created    |       |            |            |          | EXISTS (constraint)
 hafd.blocks                | blocks_signing_key_not_null                        | created    |       |            |            |          | EXISTS (constraint)
 hafd.blocks                | blocks_signing_key_not_null                        | created    |       |            |            |          | EXISTS (constraint)
 hafd.blocks                | blocks_transaction_merkle_root_not_null            | created    |       |            |            |          | EXISTS (constraint)
 hafd.blocks                | blocks_transaction_merkle_root_not_null            | created    |       |            |            |          | EXISTS (constraint)
 hafd.blocks                | blocks_witness_signature_not_null                  | created    |       |            |            |          | EXISTS (constraint)
 hafd.blocks                | blocks_witness_signature_not_null                  | created    |       |            |            |          | EXISTS (constraint)
 hafd.blocks                | fk_1_hive_blocks                                   | created    |       |            |            |          | EXISTS (constraint)
 hafd.blocks                | hive_blocks_created_at_idx                         | created    |       |            |            |          | EXISTS
 hafd.blocks                | hive_blocks_producer_account_id_idx                | created    |       |            |            |          | EXISTS
 hafd.blocks                | pk_hive_blocks                                     | created    |       |            |            |          | EXISTS
 hafd.hive_state            | fk_1_hive_irreversible_data                        | created    |       |            |            |          | EXISTS (constraint)
 hafd.operations            | hive_operations_block_num_id_idx                   | created    |       |            |            |          | EXISTS
 hafd.operations            | hive_operations_block_num_trx_in_block_idx         | created    |       |            |            |          | EXISTS
 hafd.operations            | hive_operations_op_type_id_block_num               | created    |       |            |            |          | EXISTS
 hafd.operations            | operations_id_not_null                             | created    |       |            |            |          | EXISTS (constraint)
 hafd.operations            | operations_id_not_null                             | created    |       |            |            |          | EXISTS (constraint)
 hafd.operations            | operations_op_pos_not_null                         | created    |       |            |            |          | EXISTS (constraint)
 hafd.operations            | operations_op_pos_not_null                         | created    |       |            |            |          | EXISTS (constraint)
 hafd.operations            | operations_op_type_id_not_null                     | created    |       |            |            |          | EXISTS (constraint)
 hafd.operations            | operations_op_type_id_not_null                     | created    |       |            |            |          | EXISTS (constraint)
 hafd.operations            | operations_trx_in_block_not_null                   | created    |       |            |            |          | EXISTS (constraint)
 hafd.operations            | operations_trx_in_block_not_null                   | created    |       |            |            |          | EXISTS (constraint)
 hafd.operations            | pk_hive_operations                                 | created    |       |            |            |          | EXISTS
 hafd.transactions          | fk_1_hive_transactions                             | created    |       |            |            |          | EXISTS (constraint)
 hafd.transactions          | hive_transactions_block_num_trx_in_block_idx       | created    |       |            |            |          | EXISTS
 hafd.transactions          | pk_hive_transactions                               | created    |       |            |            |          | EXISTS
 hafd.transactions          | transactions_block_num_not_null                    | created    |       |            |            |          | EXISTS (constraint)
 hafd.transactions          | transactions_block_num_not_null                    | created    |       |            |            |          | EXISTS (constraint)
 hafd.transactions          | transactions_expiration_not_null                   | created    |       |            |            |          | EXISTS (constraint)
 hafd.transactions          | transactions_expiration_not_null                   | created    |       |            |            |          | EXISTS (constraint)
 hafd.transactions          | transactions_ref_block_num_not_null                | created    |       |            |            |          | EXISTS (constraint)
 hafd.transactions          | transactions_ref_block_num_not_null                | created    |       |            |            |          | EXISTS (constraint)
 hafd.transactions          | transactions_ref_block_prefix_not_null             | created    |       |            |            |          | EXISTS (constraint)
 hafd.transactions          | transactions_ref_block_prefix_not_null             | created    |       |            |            |          | EXISTS (constraint)
 hafd.transactions          | transactions_trx_hash_not_null                     | created    |       |            |            |          | EXISTS (constraint)
 hafd.transactions          | transactions_trx_hash_not_null                     | created    |       |            |            |          | EXISTS (constraint)
 hafd.transactions          | transactions_trx_in_block_not_null                 | created    |       |            |            |          | EXISTS (constraint)
 hafd.transactions          | transactions_trx_in_block_not_null                 | created    |       |            |            |          | EXISTS (constraint)
 hafd.transactions_multisig | fk_1_hive_transactions_multisig                    | created    |       |            |            |          | EXISTS (constraint)
 hafd.transactions_multisig | pk_hive_transactions_multisig                      | created    |       |            |            |          | EXISTS
 hafd.transactions_multisig | transactions_multisig_signature_not_null           | created    |       |            |            |          | EXISTS (constraint)
 hafd.transactions_multisig | transactions_multisig_signature_not_null           | created    |       |            |            |          | EXISTS (constraint)
 hafd.transactions_multisig | transactions_multisig_trx_hash_not_null            | created    |       |            |            |          | EXISTS (constraint)
 hafd.transactions_multisig | transactions_multisig_trx_hash_not_null            | created    |       |            |            |          | EXISTS (constraint)
(87 rows)