explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VZrW : this-is-it

Settings
# exclusive inclusive rows x rows loops node
1. 10.263 51.503 ↑ 1,235.9 12 1

Hash Join (cost=3,166.44..5,122.48 rows=14,831 width=71) (actual time=36.082..51.503 rows=12 loops=1)

  • Hash Cond: ((c.client_key)::text = (r.client_key)::text)
  • Join Filter: ((hashed SubPlan 1) OR (hashed SubPlan 2))
  • Rows Removed by Join Filter: 8762
2. 5.304 5.304 ↑ 1.0 21,761 1

Seq Scan on clients c (cost=0.00..1,550.61 rows=21,761 width=32) (actual time=0.004..5.304 rows=21,761 loops=1)

3. 4.287 35.925 ↑ 2.3 8,774 1

Hash (cost=2,895.50..2,895.50 rows=19,775 width=75) (actual time=35.925..35.925 rows=8,774 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1230kB
4. 10.708 31.638 ↑ 2.3 8,774 1

Hash Join (cost=1,720.69..2,895.50 rows=19,775 width=75) (actual time=15.615..31.638 rows=8,774 loops=1)

  • Hash Cond: ((r.account_key)::text = (a.account_key)::text)
5. 5.460 5.460 ↑ 1.0 24,150 1

Seq Scan on client_accounts r (cost=0.00..886.50 rows=24,150 width=44) (actual time=0.003..5.460 rows=24,150 loops=1)

6. 8.134 15.470 ↑ 1.0 19,764 1

Hash (cost=1,473.64..1,473.64 rows=19,764 width=54) (actual time=15.470..15.470 rows=19,764 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1821kB
7. 7.336 7.336 ↑ 1.0 19,764 1

Seq Scan on accounts a (cost=0.00..1,473.64 rows=19,764 width=54) (actual time=0.003..7.336 rows=19,764 loops=1)

8.          

SubPlan (forHash Join)

9. 0.006 0.006 ↑ 18.8 8 1

Seq Scan on clients_fa_tmp (cost=0.00..11.50 rows=150 width=516) (actual time=0.004..0.006 rows=8 loops=1)

10. 0.005 0.005 ↑ 12.5 12 1

Seq Scan on accounts_fa_tmp (cost=0.00..11.50 rows=150 width=516) (actual time=0.003..0.005 rows=12 loops=1)