explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8Dft

Settings
# exclusive inclusive rows x rows loops node
1. 0.055 1,127.999 ↑ 416.9 9 1

Nested Loop Left Join (cost=0.83..287,228.91 rows=3,752 width=84) (actual time=14.140..1,127.999 rows=9 loops=1)

2. 1,127.872 1,127.872 ↑ 416.9 9 1

Index Scan using "Remessa_idx_servico_data_cadastro" on "Remessa" (cost=0.56..285,744.58 rows=3,752 width=64) (actual time=14.125..1,127.872 rows=9 loops=1)

  • Index Cond: ((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[])))
  • Filter: (chave IS NULL)
  • Rows Removed by Filter: 78
3. 0.072 0.072 ↑ 1.0 1 9

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

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