explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rUG9

Settings
# exclusive inclusive rows x rows loops node
1. 2.506 42.200 ↓ 1.2 4,624 1

Sort (cost=2,850.97..2,860.38 rows=3,763 width=12) (actual time=41.989..42.200 rows=4,624 loops=1)

  • Sort Key: folder_id, order_in_folder
  • Sort Method: quicksort Memory: 409kB
2. 39.694 39.694 ↓ 0.0 4,624 1

Index Scan using index_scenarios_on_project_id on scenarios (cost=0.43..2627.49 rows=3763 widh=12) (cost=0..0 rows=0 width=0) (actual time=0.086..39.694 rows=4,624 loops=1)

  • Index Cond: (project_id = 74637)
  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 1
Planning time : 2.975 ms
Execution time : 42.471 ms