explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aByx

Settings
# exclusive inclusive rows x rows loops node
1. 0.054 0.145 ↑ 1.2 12 1

WindowAgg (cost=2.58..2.82 rows=14 width=60) (actual time=0.114..0.145 rows=12 loops=1)

2. 0.033 0.091 ↑ 1.2 12 1

Sort (cost=2.58..2.61 rows=14 width=28) (actual time=0.089..0.091 rows=12 loops=1)

  • Sort Key: s.nom_service
  • Sort Method: quicksort Memory: 25kB
3. 0.026 0.058 ↑ 1.2 12 1

Hash Join (cost=1.09..2.31 rows=14 width=28) (actual time=0.043..0.058 rows=12 loops=1)

  • Hash Cond: (e.num_service = s.num_service)
4. 0.015 0.015 ↑ 1.2 12 1

Seq Scan on employes e (cost=0.00..1.14 rows=14 width=22) (actual time=0.012..0.015 rows=12 loops=1)

5. 0.007 0.017 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=14) (actual time=0.017..0.017 rows=4 loops=1)

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

Seq Scan on services s (cost=0.00..1.04 rows=4 width=14) (actual time=0.007..0.010 rows=4 loops=1)