explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ykdo

Settings
# exclusive inclusive rows x rows loops node
1. 5.171 5.185 ↓ 1.9 27,516 1

Seq Scan on public.mv_log_accounts (cost=10.89..824.06 rows=14,351 width=18) (actual time=1.394..5.185 rows=27,516 loops=1)

  • Output: mv_log_accounts.op, mv_log_accounts.aid, mv_log_accounts.txid64
  • Filter: (mv_log_accounts.txid64 > $0)
  • Rows Removed by Filter: 15538
  • Buffers: shared hit=276
2.          

Initplan (for Seq Scan)

3. 0.004 0.014 ↑ 1.0 1 1

Aggregate (cost=10.88..10.89 rows=1 width=8) (actual time=0.014..0.014 rows=1 loops=1)

  • Output: max(mv_metadata.txid64)
  • Buffers: shared hit=1
4. 0.010 0.010 ↓ 8.0 8 1

Seq Scan on public.mv_metadata (cost=0.00..10.88 rows=1 width=8) (actual time=0.009..0.010 rows=8 loops=1)

  • Output: mv_metadata.schema_name, mv_metadata.table_name, mv_metadata.txid64, mv_metadata.group_id
  • Filter: ((mv_metadata.table_name)::text = 'mv_log_accounts'::text)
  • Rows Removed by Filter: 4
  • Buffers: shared hit=1