explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WNb

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 60,596.037 132,855.671 ↓ 1.0 1,968,677 1

Sort (cost=604,271.920..609,044.550 rows=1,909,054 width=361) (actual time=131,295.136..132,855.671 rows=1,968,677 loops=1)

  • Sort Key: tango
  • Sort Method: quicksort Memory: 1304617kB
2. 72,259.634 72,259.634 ↓ 1.0 1,968,677 1

Index Scan using juliet on lima (cost=0.000..405,115.340 rows=1,909,054 width=361) (actual time=0.030..72,259.634 rows=1,968,677 loops=1)

  • Index Cond: (mike < 9000000)