explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WmkL

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 626.358 ↑ 1.0 10 1

Limit (cost=0.56..2.80 rows=10 width=78) (actual time=626.332..626.358 rows=10 loops=1)

2. 626.354 626.354 ↑ 1,471,276.4 10 1

Index Scan Backward using "Executor_expr_idx" on "Executor" (cost=0.56..3,293,442.80 rows=14,712,764 width=78) (actual time=626.329..626.354 rows=10 loops=1)

  • Filter: (((payload -> 'length'::text))::text <> 'null'::text)
  • Rows Removed by Filter: 770,276
Planning time : 0.142 ms
Execution time : 626.392 ms