explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 160O

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 72.776 ↑ 1.0 1 1

Nested Loop (cost=1,008.60..15,437.08 rows=1 width=78) (actual time=72.647..72.776 rows=1 loops=1)

2. 0.000 72.742 ↑ 1.0 1 1

Nested Loop (cost=1,008.46..15,436.82 rows=1 width=66) (actual time=72.612..72.742 rows=1 loops=1)

3. 0.034 0.826 ↑ 1.0 1 1

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

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

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

5. 0.004 0.765 ↑ 1.0 1 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
6. 0.761 0.761 ↑ 1.0 1 1

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

  • Index Cond: (id_saldo = 444,851)
7. 5.445 73.942 ↑ 1.0 1 1

Gather (cost=1,000.00..15,424.85 rows=1 width=16) (actual time=71.823..73.942 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 1
8. 68.497 68.497 ↓ 0.0 0 2 / 2

Parallel Seq Scan on saldo_abate sa (cost=0.00..14,424.75 rows=1 width=16) (actual time=58.177..68.497 rows=0 loops=2)

  • Filter: (id_saldo = 444,851)
  • Rows Removed by Filter: 560,136
9. 0.030 0.030 ↑ 1.0 1 1

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

  • Index Cond: (id = e.id_especie)