explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Fr8f

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 143,048.727 ↑ 174.6 87 1

Nested Loop Left Join (cost=1,000.27..1,275,541.52 rows=15,193 width=84) (actual time=10,897.717..143,048.727 rows=87 loops=1)

2. 22.358 143,067.691 ↑ 174.6 87 1

Gather (cost=1,000.00..1,270,768.91 rows=15,193 width=64) (actual time=10,897.675..143,067.691 rows=87 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 143,045.333 143,045.333 ↑ 223.4 17 5 / 5

Parallel Seq Scan on "Remessa" (cost=0.00..1,268,249.61 rows=3,798 width=64) (actual time=21,546.361..143,045.333 rows=17 loops=5)

  • Filter: ((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: 3,410,103
4. 0.609 0.609 ↑ 1.0 1 87

Index Scan using "Servico_pkey" on "Servico" (cost=0.27..0.31 rows=1 width=24) (actual time=0.007..0.007 rows=1 loops=87)

  • Index Cond: ("Remessa".fk_servico = codigo)