explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hhL4

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 9.258 ↑ 1.0 1 1

Limit (cost=1.14..12.20 rows=1 width=87) (actual time=9.257..9.258 rows=1 loops=1)

2. 0.001 9.256 ↑ 23,706.0 1 1

Nested Loop (cost=1.14..262,123.44 rows=23,706 width=87) (actual time=9.256..9.256 rows=1 loops=1)

3. 0.005 9.242 ↑ 23,706.0 1 1

Nested Loop (cost=0.87..259,689.20 rows=23,706 width=95) (actual time=9.242..9.242 rows=1 loops=1)

4. 9.221 9.221 ↑ 23,706.0 1 1

Index Only Scan Backward using optimizer_job_subset_pkey on optimizer_job_subset subsets1_ (cost=0.43..164,204.69 rows=23,706 width=16) (actual time=9.221..9.221 rows=1 loops=1)

  • Index Cond: (subset_id = '1253'::bigint)
  • Heap Fetches: 1
5. 0.016 0.016 ↑ 1.0 1 1

Index Scan using pk_optimizer_job on optimizer_job optimizerj0_ (cost=0.43..4.03 rows=1 width=87) (actual time=0.016..0.016 rows=1 loops=1)

  • Index Cond: (id = subsets1_.optimizer_job_id)
6. 0.002 0.013 ↑ 1.0 1 1

Materialize (cost=0.27..4.38 rows=1 width=8) (actual time=0.013..0.013 rows=1 loops=1)

7. 0.011 0.011 ↑ 1.0 1 1

Index Only Scan using pk_subset on subset subset2_ (cost=0.27..4.38 rows=1 width=8) (actual time=0.011..0.011 rows=1 loops=1)

  • Index Cond: (id = '1253'::bigint)
  • Heap Fetches: 1
Planning time : 0.313 ms
Execution time : 9.289 ms