explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tiEJ

Settings
# exclusive inclusive rows x rows loops node
1. 2.440 98,837.234 ↓ 0.0 0 1

Gather (cost=1,017.16..268,925.05 rows=12,355 width=2,385) (actual time=98,836.993..98,837.234 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 0
2. 190.998 98,834.794 ↓ 0.0 0 1

Hash Join (cost=17.16..266,689.55 rows=5,148 width=2,385) (actual time=98,834.794..98,834.794 rows=0 loops=1)

  • Hash Cond: ((np.cpf_cnpj)::text = (analise_fiscal_fornecedores_confiaveis.cnpj)::text)
3. 22,625.192 98,643.555 ↓ 2.3 103,473 1

Nested Loop (cost=1.44..266,556.71 rows=44,568 width=2,385) (actual time=0.206..98,643.555 rows=103,473 loops=1)

4. 31,746.011 76,018.151 ↓ 2.3 103,473 1

Nested Loop (cost=1.00..197,103.74 rows=44,568 width=2,228) (actual time=0.159..76,018.151 rows=103,473 loops=1)

5. 44,271.842 44,271.842 ↓ 2.3 103,473 1

Parallel Index Scan using nfes_itens_codigo_barras_inserted_at_index on nfes_itens i (cost=0.57..104,550.74 rows=44,568 width=1,537) (actual time=0.080..44,271.842 rows=103,473 loops=1)

  • Index Cond: ((codigo_barras)::text = '7891150025301'::text)
6. 0.298 0.298 ↑ 1.0 1 103,473

Index Scan using ef_nfe_pkey on nfes n (cost=0.44..2.08 rows=1 width=691) (actual time=0.298..0.298 rows=1 loops=103,473)

  • Index Cond: (id = i.nfe_id)
7. 0.212 0.212 ↑ 1.0 1 103,473

Index Scan using nfes_participantes_pkey on nfes_participantes np (cost=0.44..1.56 rows=1 width=157) (actual time=0.212..0.212 rows=1 loops=103,473)

  • Index Cond: (id = n.emitente_id)
8. 0.125 0.241 ↑ 1.0 432 1

Hash (cost=10.32..10.32 rows=432 width=15) (actual time=0.241..0.241 rows=432 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 28kB
9. 0.116 0.116 ↑ 1.0 432 1

Seq Scan on analise_fiscal_fornecedores_confiaveis (cost=0.00..10.32 rows=432 width=15) (actual time=0.016..0.116 rows=432 loops=1)

Planning time : 10.501 ms
Execution time : 98,837.856 ms