explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TUZO

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 12.752 ↓ 0.0 0 1

Sort (cost=1,402.63..1,402.78 rows=58 width=33) (actual time=12.752..12.752 rows=0 loops=1)

  • Sort Key: "TabProspeccao"."tproUF", (random())
  • Sort Method: quicksort Memory: 25kB
2. 2.552 12.740 ↓ 0.0 0 1

Hash Anti Join (cost=528.11..1,400.93 rows=58 width=33) (actual time=12.740..12.740 rows=0 loops=1)

  • Hash Cond: ("TabProspeccao"."tproID" = "TabProspeccaoSituacaoEmpresa"."tpsetproID")
3. 4.059 4.059 ↑ 1.0 7,711 1

Seq Scan on "TabProspeccao" (cost=0.00..824.11 rows=7,711 width=25) (actual time=0.009..4.059 rows=7,711 loops=1)

  • Filter: ("tproSituacao" = 'ATIVA'::text)
  • Rows Removed by Filter: 58
4. 2.288 6.129 ↑ 1.0 7,711 1

Hash (cost=431.73..431.73 rows=7,711 width=4) (actual time=6.129..6.129 rows=7,711 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 336kB
5. 3.841 3.841 ↑ 1.0 7,711 1

Seq Scan on "TabProspeccaoSituacaoEmpresa" (cost=0.00..431.73 rows=7,711 width=4) (actual time=0.286..3.841 rows=7,711 loops=1)

  • Filter: ("tpsetemID" = 6)
  • Rows Removed by Filter: 15147