explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oCVe

Settings
# exclusive inclusive rows x rows loops node
1. 4,048.355 5,377.559 ↓ 1.0 19,354,312 1

Hash Join (cost=8,131.73..394,962.78 rows=19,154,775 width=16) (actual time=90.921..5,377.559 rows=19,354,312 loops=1)

  • Hash Cond: (tb_investor_owner.id_investor_owner = tb_investor.id_investor)
2. 1,238.624 1,238.624 ↓ 1.0 19,354,313 1

Seq Scan on tb_investor_owner (cost=0.00..336,027.36 rows=19,353,036 width=16) (actual time=0.006..1,238.624 rows=19,354,313 loops=1)

3. 25.577 90.580 ↓ 1.0 107,928 1

Hash (cost=6,782.76..6,782.76 rows=107,918 width=4) (actual time=90.580..90.580 rows=107,928 loops=1)

  • Buckets: 131,072 Batches: 1 Memory Usage: 4,819kB
4. 65.003 65.003 ↓ 1.0 107,928 1

Index Only Scan using tb_investor_idx2 on tb_investor (cost=0.42..6,782.76 rows=107,918 width=4) (actual time=0.034..65.003 rows=107,928 loops=1)

  • Index Cond: (id_contract = 8)
  • Heap Fetches: 74,389
Planning time : 0.348 ms
Execution time : 6,002.278 ms