explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eNY3

Settings
# exclusive inclusive rows x rows loops node
1. 7.872 92.480 ↑ 7.6 166 1

Aggregate (cost=7,109.94..7,122.61 rows=1,267 width=12) (actual time=92.435..92.48 rows=166 loops=1)

2. 37.467 84.608 ↓ 1.1 17,068 1

Hash Join (cost=2,621.31..7,031.2 rows=15,747 width=12) (actual time=24.163..84.608 rows=17,068 loops=1)

3. 23.035 23.035 ↑ 1.0 38,637 1

Seq Scan on operacao o (cost=0..3,769.41 rows=38,641 width=16) (actual time=0.005..23.035 rows=38,637 loops=1)

4. 6.022 24.106 ↓ 1.1 17,068 1

Hash (cost=2,424.47..2,424.47 rows=15,747 width=12) (actual time=24.106..24.106 rows=17,068 loops=1)

5. 18.084 18.084 ↓ 1.1 17,068 1

Seq Scan on operacao_assinatura oa (cost=0..2,424.47 rows=15,747 width=12) (actual time=0.021..18.084 rows=17,068 loops=1)