explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4Ohi : Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: plan #vGml; plan #4VVA; plan #KDbU; plan #gQN; plan #orM9; plan #WWMl

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 1,401.875 23,711.763 ↓ 33.3 109,887 1

Nested Loop (cost=1.86..12,034.00 rows=3,297 width=224) (actual time=0.181..23,711.763 rows=109,887 loops=1)

2. 715.240 20,771.470 ↓ 33.3 109,887 1

Nested Loop (cost=1.86..11,918.30 rows=3,297 width=195) (actual time=0.120..20,771.470 rows=109,887 loops=1)

3. 680.442 17,528.829 ↓ 33.3 109,887 1

Nested Loop (cost=1.57..10,797.41 rows=3,297 width=170) (actual time=0.105..17,528.829 rows=109,887 loops=1)

4. 483.752 1,024.659 ↓ 33.3 109,887 1

Hash Join (cost=1.14..4,849.49 rows=3,297 width=145) (actual time=0.083..1,024.659 rows=109,887 loops=1)

  • Hash Cond: ((documento.idestado)::text = (estado.idestado)::text)
5. 540.870 540.870 ↑ 1.0 109,887 1

Seq Scan on documento (cost=0.00..3,853.87 rows=109,887 width=139) (actual time=0.029..540.870 rows=109,887 loops=1)

6. 0.012 0.037 ↑ 1.0 6 1

Hash (cost=1.06..1.06 rows=6 width=14) (actual time=0.037..0.037 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
7. 0.025 0.025 ↑ 1.0 6 1

Seq Scan on estado (cost=0.00..1.06 rows=6 width=14) (actual time=0.019..0.025 rows=6 loops=1)

8. 15,823.728 15,823.728 ↑ 1.0 1 109,887

Index Scan using personas_pkey on personas (cost=0.43..1.79 rows=1 width=32) (actual time=0.143..0.144 rows=1 loops=109,887)

  • Index Cond: ((ci)::text = (documento.ci)::text)
9. 2,527.401 2,527.401 ↑ 1.0 1 109,887

Index Scan using empresa_pkey on empresa (cost=0.29..0.33 rows=1 width=30) (actual time=0.021..0.023 rows=1 loops=109,887)

  • Index Cond: ((nro_patronal)::text = (documento.nro_patronal)::text)
10. 1,538.418 1,538.418 ↑ 1.0 1 109,887

Index Scan using tipo_idtipo_idx on tipo (cost=0.00..0.02 rows=1 width=33) (actual time=0.012..0.014 rows=1 loops=109,887)

  • Index Cond: (idtipo = documento.idtipo)