explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zfsa

Settings
# exclusive inclusive rows x rows loops node
1. 174.847 187.595 ↓ 136.6 13,664 1

Nested Loop (cost=526.73..1,368.24 rows=100 width=16) (actual time=7.548..187.595 rows=13,664 loops=1)

  • Output: delta_t.aid, acc.bid, acc.abalance
  • Inner Unique: true
  • Buffers: shared hit=54728, local hit=176
  • -> Index Scan using pgbench_accounts_pkey on public.pgbench_accounts acc (cost=0.42..8.40 rows=1 width=12) (actual time=0.012..0.012 r
2. 3.075 12.748 ↓ 136.6 13,664 1

Unique (cost=526.30..526.99 rows=100 width=8) (actual time=7.485..12.748 rows=13,664 loops=1)

  • Output: delta_t.aid
  • Buffers: shared hit=3, local hit=176
  • Output: acc.aid, acc.bid, acc.abalance, acc.filler
  • Index Cond: (acc.aid = delta_t.aid)
  • Buffers: shared hit=54725
3. 6.046 9.673 ↓ 99.7 13,758 1

Sort (cost=526.30..526.65 rows=138 width=8) (actual time=7.484..9.673 rows=13,758 loops=1)

  • Output: delta_t.aid
  • Sort Key: delta_t.aid
  • Sort Method: quicksort Memory: 1029kB
  • Buffers: shared hit=3, local hit=176
4. 3.627 3.627 ↓ 99.7 13,758 1

Seq Scan on pg_temp_7.delta_t (cost=0.00..521.40 rows=138 width=8) (actual time=0.013..3.627 rows=13,758 loops=1)

  • Output: delta_t.aid
  • Filter: (delta_t.op = 'I'::bpchar)
  • Rows Removed by Filter: 13758
  • Buffers: local hit=176
Planning time : 0.336 ms
Execution time : 196.715 ms