explain.depesz.com

PostgreSQL's explain analyze made readable

Result: q6UQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.834 2,765.815 ↑ 5.9 264 1

Hash Left Join (cost=71.77..6,034.53 rows=1,565 width=91) (actual time=43.732..2,765.815 rows=264 loops=1)

  • Hash Cond: ("Servico".fk_cliente = "Servico.Cliente".codigo)
2. 2.674 2,764.953 ↑ 5.9 264 1

Hash Join (cost=68.42..6,026.78 rows=1,565 width=56) (actual time=43.698..2,764.953 rows=264 loops=1)

  • Hash Cond: ("Remessa".fk_servico = "Servico".codigo)
3. 2,761.998 2,761.998 ↑ 6.0 264 1

Index Scan using idx_remessa_situacao_tipo_remessa_data_coleta on "Remessa" (cost=0.56..5,954.69 rows=1,574 width=36) (actual time=43.400..2,761.998 rows=264 loops=1)

  • Index Cond: ((fk_situacao_remessa = 5) AND (fk_tipo_remessa = ANY ('{1,3,4}'::integer[])) AND (data_coleta >= '2019-05-28 00:00:00-03'::timestamp with time zone) AND (data_coleta <= '2019-08-17 23:59:00-03'::timestamp with time zone))
4. 0.037 0.281 ↑ 1.0 171 1

Hash (cost=65.72..65.72 rows=171 width=28) (actual time=0.281..0.281 rows=171 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
5. 0.244 0.244 ↑ 1.0 171 1

Seq Scan on "Servico" (cost=0.00..65.72 rows=171 width=28) (actual time=0.013..0.244 rows=171 loops=1)

  • Filter: (show_dashboard IS NOT FALSE)
  • Rows Removed by Filter: 1
6. 0.012 0.028 ↓ 1.1 63 1

Hash (cost=2.60..2.60 rows=60 width=39) (actual time=0.028..0.028 rows=63 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
7. 0.016 0.016 ↓ 1.1 63 1

Seq Scan on "Cliente" "Servico.Cliente" (cost=0.00..2.60 rows=60 width=39) (actual time=0.005..0.016 rows=63 loops=1)

Planning time : 0.717 ms