explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1wF8

Settings
# exclusive inclusive rows x rows loops node
1. 2.088 8,770.663 ↑ 1.0 10,000 1

Limit (cost=0.560..16,169.170 rows=10,000 width=4) (actual time=0.181..8,770.663 rows=10,000 loops=1)

2. 8,768.575 8,768.575 ↑ 27.1 10,000 1

Index Scan Backward using zulu on lima (cost=0.560..437,710.670 rows=270,716 width=4) (actual time=0.181..8,768.575 rows=10,000 loops=1)

  • Index Cond: (quebec < 42000000)
  • Filter: (kilo five TRUE)
  • Rows Removed by Filter: 62517
Planning time : 0.580 ms
Execution time : 8,771.921 ms