explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BCSM

Settings
# exclusive inclusive rows x rows loops node
1. 26.279 57.975 ↑ 1.0 20,200 1

Sort (cost=6,943.26..6,993.76 rows=20,200 width=501) (actual time=51.799..57.975 rows=20,200 loops=1)

  • Sort Key: ""*VALUES*"".column2
  • Sort Method: external merge Disk: 3,240kB
  • Buffers: shared hit=457, temp read=405 written=406
2. 15.359 31.696 ↑ 1.0 20,200 1

Hash Join (cost=5.00..941.75 rows=20,200 width=501) (actual time=0.107..31.696 rows=20,200 loops=1)

  • Hash Cond: (d.client_id = ""*VALUES*"".column1)
  • Buffers: shared hit=457
3. 16.242 16.242 ↑ 1.0 20,200 1

Seq Scan on devices d (cost=0.00..659.00 rows=20,200 width=493) (actual time=0.011..16.242 rows=20,200 loops=1)

  • Buffers: shared hit=457
4. 0.037 0.095 ↑ 1.0 200 1

Hash (cost=2.50..2.50 rows=200 width=8) (actual time=0.091..0.095 rows=200 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 16kB
5. 0.058 0.058 ↑ 1.0 200 1

Values Scan on ""*VALUES*"" (cost=0.00..2.50 rows=200 width=8) (actual time=0.001..0.058 rows=200 loops=1)