explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KchA

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 1,317.184 ↑ 1.0 1 1

Limit (cost=1.14..12.20 rows=1 width=87) (actual time=1,317.181..1,317.184 rows=1 loops=1)

2. 0.002 1,317.170 ↑ 23,706.0 1 1

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

3. 0.003 1,314.332 ↑ 23,706.0 1 1

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

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

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

  • Index Cond: (id = subsets1_.optimizer_job_id)
6. 0.982 2.836 ↑ 1.0 1 1

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

7. 1.854 1.854 ↑ 1.0 1 1

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

  • Index Cond: (id = '1253'::bigint)
  • Heap Fetches: 1
Planning time : 30.953 ms
Execution time : 1,318.688 ms