explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Vt1g

Settings
# exclusive inclusive rows x rows loops node
1. 0.292 9.182 ↑ 1.0 57 1

Hash Join (cost=102.28..154.56 rows=57 width=142) (actual time=7.922..9.182 rows=57 loops=1)

  • Buffers: shared hit=4
2. 8.854 8.854 ↓ 1.6 1,589 1

Foreign Scan (cost=100..149.67 rows=989 width=126) (actual time=7.819..8.854 rows=1,589 loops=1)

3. 0.017 0.036 ↑ 1.0 57 1

Hash (cost=1.57..1.57 rows=57 width=32) (actual time=0.036..0.036 rows=57 loops=1)

  • Buffers: shared hit=1
4. 0.019 0.019 ↑ 1.0 57 1

Seq Scan on account_client account_client (cost=0..1.57 rows=57 width=32) (actual time=0.008..0.019 rows=57 loops=1)

  • Buffers: shared hit=1
Planning time : 1.736 ms
Execution time : 22.873 ms