explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 69.603 69.603 ↓ 6.5 158,062 1

Index Scan using ledger__created on ledger (cost=0.58..2,559.47 rows=24,494 width=152) (actual time=0.022..69.603 rows=158,062 loops=1)

  • Index Cond: (created > '2020-02-10 08:54:39.857789+00'::timestamp with time zone)
  • Buffers: shared hit=40569
Planning time : 0.135 ms
Execution time : 78.305 ms