explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Lg2v

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 62.079 ↓ 2.0 2 1

Nested Loop (cost=68,498.10..146,310.01 rows=1 width=953) (actual time=42.887..62.079 rows=2 loops=1)

2. 0.009 62.023 ↓ 2.0 2 1

Nested Loop (cost=68,415.10..146,224.82 rows=1 width=896) (actual time=42.844..62.023 rows=2 loops=1)

3. 0.000 61.982 ↓ 2.0 2 1

Hash Join (cost=68,332.10..146,137.68 rows=1 width=896) (actual time=42.812..61.982 rows=2 loops=1)

  • Hash Cond: (rep.arq_numero_guia_prest = guia.guinumprestador)
4. 0.000 34.435 ↑ 10.0 1 1

Gather (cost=1,000.00..78,767.58 rows=10 width=877) (actual time=6.551..34.435 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 41.109 41.109 ↓ 0.0 0 3 / 3

Parallel Seq Scan on fiboarquivorepositorio rep (cost=0.00..77,766.58 rows=4 width=877) (actual time=34.758..41.109 rows=0 loops=3)

  • Filter: (arq_nome ~~ '%340067652731%'::text)
  • Rows Removed by Filter: 32965
6. 0.365 36.237 ↓ 2.3 1,035 1

Hash (cost=66,886.10..66,886.10 rows=446 width=27) (actual time=36.237..36.237 rows=1,035 loops=1)

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 76kB
7. 9.678 35.872 ↓ 2.3 1,035 1

Gather (cost=1,000.00..66,886.10 rows=446 width=27) (actual time=0.846..35.872 rows=1,035 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
8. 26.194 26.194 ↓ 1.9 345 3 / 3

Parallel Seq Scan on fiboguia guia (cost=0.00..65,841.50 rows=186 width=27) (actual time=0.359..26.194 rows=345 loops=3)

  • Filter: ((discriminador = 'CONVENIO'::text) AND (guivlrapresentado = '0'::numeric))
  • Rows Removed by Filter: 25264
9. 0.032 0.032 ↑ 1.0 1 2

Index Scan using fiboprotocolo_pkey on fiboprotocolo prot (cost=83.00..87.14 rows=1 width=16) (actual time=0.016..0.016 rows=1 loops=2)

  • Index Cond: (id = guia.guiprotocolo)
10. 0.050 0.050 ↑ 1.0 1 2

Index Scan using fiboarquivo_pkey on fiboarquivo arq (cost=83.00..85.18 rows=1 width=73) (actual time=0.025..0.025 rows=1 loops=2)

  • Index Cond: (id = prot.arquivo)
Planning time : 4.327 ms
Execution time : 71.082 ms