explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wPZ9

Settings
# exclusive inclusive rows x rows loops node
1. 0.139 0.816 ↑ 1.0 724 1

Hash Join (cost=14.50..245.34 rows=724 width=160) (actual time=0.109..0.816 rows=724 loops=1)

  • Hash Cond: (employe.unite_administrative = unite_administrative.id)
2. 0.588 0.588 ↑ 1.0 724 1

Seq Scan on employe (cost=0.00..221.74 rows=724 width=152) (actual time=0.013..0.588 rows=724 loops=1)

  • Filter: actif
  • Rows Removed by Filter: 1250
3. 0.030 0.089 ↑ 1.0 197 1

Hash (cost=12.00..12.00 rows=200 width=16) (actual time=0.089..0.089 rows=197 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
4. 0.059 0.059 ↑ 1.0 197 1

Seq Scan on unite_administrative (cost=0.00..12.00 rows=200 width=16) (actual time=0.005..0.059 rows=197 loops=1)

Planning time : 0.200 ms
Execution time : 0.864 ms