explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rTPT

Settings
# exclusive inclusive rows x rows loops node
1. 0.188 2.149 ↑ 5.9 264 1

Hash Left Join (cost=71.77..6,051.36 rows=1,565 width=91) (actual time=0.835..2.149 rows=264 loops=1)

  • Hash Cond: ("Servico".fk_cliente = "Servico.Cliente".codigo)
2. 0.374 1.892 ↑ 5.9 264 1

Hash Join (cost=68.42..6,043.61 rows=1,565 width=56) (actual time=0.755..1.892 rows=264 loops=1)

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

Index Scan using idx_rms_situacao_data_coleta_postagem on "Remessa" (cost=0.56..5,971.52 rows=1,574 width=36) (actual time=0.044..0.824 rows=264 loops=1)

  • Index Cond: ((fk_situacao_remessa = 5) 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))
  • Filter: (fk_tipo_remessa = ANY ('{1,3,4}'::integer[]))
4. 0.095 0.694 ↑ 1.0 171 1

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

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

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

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

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

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

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

Planning time : 1.553 ms