explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yyST

Settings
# exclusive inclusive rows x rows loops node
1. 18.641 55.818 ↓ 0.0 0 1

Gather (cost=40,686.58..128,755.48 rows=1 width=953) (actual time=47.916..55.818 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.307 37.177 ↓ 0.0 0 3 / 3

Parallel Hash Join (cost=39,686.58..127,755.38 rows=1 width=953) (actual time=37.176..37.177 rows=0 loops=3)

  • Hash Cond: (rep.arq_numero_guia_prest = guia.guinumprestador)
3. 0.000 0.000 ↓ 0.0 0 / 3

Parallel Seq Scan on fiboarquivorepositorio rep (cost=0.00..57,163.04 rows=41,207 width=877) (never executed)

4. 0.048 36.870 ↓ 0.0 0 3 / 3

Parallel Hash (cost=39,685.58..39,685.58 rows=1 width=84) (actual time=36.870..36.870 rows=0 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 0kB
5. 0.001 36.822 ↓ 0.0 0 3 / 3

Nested Loop (cost=166.50..39,685.58 rows=1 width=84) (actual time=36.822..36.822 rows=0 loops=3)

6. 0.009 36.808 ↓ 0.0 0 3 / 3

Nested Loop (cost=83.00..39,496.50 rows=2 width=73) (actual time=29.875..36.808 rows=0 loops=3)

7. 36.783 36.783 ↓ 0.0 0 3 / 3

Parallel Seq Scan on fiboarquivo arq (cost=0.00..39,320.50 rows=2 width=73) (actual time=29.851..36.783 rows=0 loops=3)

  • Filter: (arq_nome ~~ '%015559933_PAULO AGOSTINHO DEZEN_0000789097__2019-12-06.TXT%'::text)
  • Rows Removed by Filter: 12310
8. 0.016 0.016 ↑ 1.0 1 1 / 3

Index Scan using idx_fiboprotocolo_arquivo_idx on fiboprotocolo prot (cost=83.00..87.50 rows=1 width=16) (actual time=0.048..0.049 rows=1 loops=1)

  • Index Cond: (arquivo = arq.id)
9. 0.013 0.013 ↓ 0.0 0 1 / 3

Index Scan using idx_fiboguia_guiprotocolo_idx on fiboguia guia (cost=83.50..94.04 rows=1 width=27) (actual time=0.038..0.038 rows=0 loops=1)

  • Index Cond: (guiprotocolo = prot.id)
  • Filter: ((discriminador = 'CONVENIO'::text) AND (guivlrapresentado = '0'::numeric))
Planning time : 2.135 ms
Execution time : 55.950 ms