explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dOtl

Settings
# exclusive inclusive rows x rows loops node
1. 25.360 55.749 ↑ 1.0 20,200 1

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

  • Sort Key: ""*VALUES*"".column2
  • Sort Method: external merge Disk: 3,240kB
2. 14.763 30.389 ↑ 1.0 20,200 1

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

  • Hash Cond: (d.client_id = ""*VALUES*"".column1)
3. 15.516 15.516 ↑ 1.0 20,200 1

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

4. 0.038 0.110 ↑ 1.0 200 1

Hash (cost=2.50..2.50 rows=200 width=8) (actual time=0.109..0.110 rows=200 loops=1)

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

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