explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sJDCy

Settings
# exclusive inclusive rows x rows loops node
1. 1.302 2.652 ↑ 1.0 6,075 1

Sort (cost=696.37..711.84 rows=6,189 width=12) (actual time=2.326..2.652 rows=6,075 loops=1)

  • Sort Key: test_pagination.x, test_pagination.y DESC, test_pagination.z
  • Sort Method: quicksort Memory: 477kB
2. 1.310 1.350 ↑ 1.0 6,075 1

Append (cost=0.41..306.61 rows=6,189 width=12) (actual time=0.026..1.350 rows=6,075 loops=1)

3. 0.027 0.027 ↓ 1.1 15 1

Index Only Scan using test_pagination_x_y_z_idx on test_pagination (cost=0.41..4.73 rows=14 width=12) (actual time=0.025..0.027 rows=15 loops=1)

  • Index Cond: ((x = 45) AND (y = 3) AND (z > 15))
  • Heap Fetches: 0
4. 0.013 0.013 ↓ 1.0 60 1

Index Only Scan using test_pagination_x_y_z_idx on test_pagination test_pagination_1 (cost=0.41..5.59 rows=59 width=12) (actual time=0.007..0.013 rows=60 loops=1)

  • Index Cond: ((x = 45) AND (y < 3))
  • Heap Fetches: 0