explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wm7z

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 147,731.907 ↑ 410.1 9 1

Nested Loop Left Join (cost=1,000.27..1,271,085.46 rows=3,691 width=84) (actual time=83,786.536..147,731.907 rows=9 loops=1)

2. 49.542 147,778.100 ↑ 410.1 9 1

Gather (cost=1,000.00..1,269,618.71 rows=3,691 width=64) (actual time=83,786.505..147,778.100 rows=9 loops=1)

  • Workers Planned: 4
  • Workers Launched: 3
3. 147,728.558 147,728.558 ↑ 461.5 2 4 / 4

Parallel Seq Scan on "Remessa" (cost=0.00..1,268,249.61 rows=923 width=64) (actual time=121,690.979..147,728.558 rows=2 loops=4)

  • Filter: ((chave IS NULL) AND (data_cadastro >= '2019-11-14 00:00:00-03'::timestamp with time zone) AND (fk_servico = ANY ('{189,207,186,188,140,131,111}'::integer[])))
  • Rows Removed by Filter: 4262648
4. 0.144 0.144 ↑ 1.0 1 9

Index Scan using "Servico_pkey" on "Servico" (cost=0.27..0.40 rows=1 width=24) (actual time=0.016..0.016 rows=1 loops=9)

  • Index Cond: ("Remessa".fk_servico = codigo)
Planning time : 1.503 ms