explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bV0W

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.124 ↑ 1.0 1 1

Nested Loop (cost=9.02..20.68 rows=1 width=78) (actual time=0.105..0.124 rows=1 loops=1)

2. 0.002 0.114 ↑ 1.0 1 1

Nested Loop (cost=8.89..20.42 rows=1 width=66) (actual time=0.095..0.114 rows=1 loops=1)

3. 0.021 0.077 ↑ 1.0 1 1

Hash Join (cost=8.46..11.96 rows=1 width=54) (actual time=0.059..0.077 rows=1 loops=1)

  • Hash Cond: (e.id = s.id_estratificacao)
4. 0.014 0.014 ↑ 1.0 118 1

Seq Scan on estratificacao e (cost=0.00..3.18 rows=118 width=50) (actual time=0.005..0.014 rows=118 loops=1)

5. 0.003 0.042 ↑ 1.0 1 1

Hash (cost=8.45..8.45 rows=1 width=8) (actual time=0.042..0.042 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
6. 0.039 0.039 ↑ 1.0 1 1

Index Scan using saldo_pkey on saldo s (cost=0.43..8.45 rows=1 width=8) (actual time=0.039..0.039 rows=1 loops=1)

  • Index Cond: (id_saldo = 444851)
7. 0.035 0.035 ↑ 1.0 1 1

Index Scan using idx_dsasaldoabate_idsaldo on saldo_abate sa (cost=0.43..8.45 rows=1 width=16) (actual time=0.034..0.035 rows=1 loops=1)

  • Index Cond: (id_saldo = 444851)
8. 0.009 0.009 ↑ 1.0 1 1

Index Scan using pk_especie on especie es (cost=0.14..0.26 rows=1 width=16) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: (id = e.id_especie)