explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PgSN : Optimization for: plan #vDFj

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.030 0.166 ↑ 1.0 250 1

Limit (cost=0.28..33.57 rows=250 width=182) (actual time=0.030..0.166 rows=250 loops=1)

  • Output: id, block_hash, network, block_number, parent_hash, parent_id, mined_at, created_at, updated_at
2. 0.136 0.136 ↑ 5.2 250 1

Index Scan Backward using ethereum_block_cache_block_number_network_index on public.ethereum_block_cache (cost=0.28..173.55 rows=1,301 width=182) (actual time=0.029..0.136 rows=250 loops=1)

  • Output: id, block_hash, network, block_number, parent_hash, parent_id, mined_at, created_at, updated_at
  • Index Cond: ((ethereum_block_cache.block_number <= 5162494) AND ((ethereum_block_cache.network)::text = 'eth'::text))