explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QDiU

Settings
# exclusive inclusive rows x rows loops node
1. 0.907 1,106.266 ↑ 1.0 1 1

Aggregate (cost=21,812.46..21,812.47 rows=1 width=0) (actual time=1,106.266..1,106.266 rows=1 loops=1)

2. 1,105.359 1,105.359 ↑ 21.1 8,827 1

Index Scan using ix_events_ack on tblevents (cost=0.56..21,347.24 rows=186,089 width=0) (actual time=2.637..1,105.359 rows=8,827 loops=1)

  • Index Cond: (evnack = false)
  • Filter: ((NOT evnack) AND evnsent AND (evntimestamp < (now() - ('10min'::cstring)::interval)))
  • Rows Removed by Filter: 994,997