explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 34m8 : Optimization for: Bad selectivity with subquery filter; plan #Hsix

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 9.218 9.218 ↓ 7.6 24,579 1

Index Scan using ledger__created on ledger (cost=0.83..342.64 rows=3,233 width=152) (actual time=0.102..9.218 rows=24,579 loops=1)

  • Index Cond: (created > current_rollup_cutoff())
  • Buffers: shared hit=6803
Planning time : 0.239 ms
Execution time : 10.354 ms