explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vGWm

Settings
# exclusive inclusive rows x rows loops node
1. 0.062 29.210 ↓ 1.2 25 1

HashAggregate (cost=14.92..15.12 rows=20 width=16) (actual time=29.185..29.210 rows=25 loops=1)

  • Group Key: u.documentid
2. 0.044 29.148 ↑ 1.0 25 1

Limit (cost=0.42..14.61 rows=25 width=32) (actual time=29.022..29.148 rows=25 loops=1)

3. 29.104 29.104 ↑ 640.2 25 1

Index Scan Backward using documentupdates_idx_failed on documentupdates u (cost=0.42..9,083.12 rows=16,004 width=32) (actual time=29.019..29.104 rows=25 loops=1)

  • Filter: ((age(date_trunc('milliseconds'::text, transaction_timestamp()), "timestamp") >= '00:01:00'::interval) AND (age("timestamp", lastupdate) <= age(date_trunc('milliseconds'::text, transaction_timestamp()), "timestamp")))
  • Rows Removed by Filter: 13752
Planning time : 1.276 ms
Execution time : 29.361 ms