explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Fd3y

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

Limit (cost=1.14..12.20 rows=1 width=87) (actual time=117.375..117.377 rows=1 loops=1)

2. 0.002 117.375 ↑ 23,706.0 1 1

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

3. 0.004 117.347 ↑ 23,706.0 1 1

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

4. 117.316 117.316 ↑ 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=117.316..117.316 rows=1 loops=1)

  • Index Cond: (subset_id = '1251'::bigint)
  • Heap Fetches: 0
5. 0.027 0.027 ↑ 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.027..0.027 rows=1 loops=1)

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

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

7. 0.024 0.024 ↑ 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.024..0.024 rows=1 loops=1)

  • Index Cond: (id = '1251'::bigint)
  • Heap Fetches: 1
Planning time : 0.607 ms
Execution time : 117.415 ms