explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KLKB

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 6.051 ↓ 3.0 3 1

Unique (cost=16.61..16.63 rows=1 width=41) (actual time=6.040..6.051 rows=3 loops=1)

2. 0.014 6.040 ↓ 3.0 3 1

Sort (cost=16.61..16.62 rows=1 width=41) (actual time=6.039..6.040 rows=3 loops=1)

  • Sort Key: laborcloud0_.id DESC, laborcloud0_.created_at, laborcloud0_.executed, laborcloud0_.labor_cloud_id, laborcloud0_.success, laborcloud0_.worker_number
  • Sort Method: quicksort Memory: 25kB
3. 0.007 6.026 ↓ 3.0 3 1

Nested Loop (cost=0.56..16.60 rows=1 width=41) (actual time=6.018..6.026 rows=3 loops=1)

4. 5.995 5.995 ↓ 3.0 3 1

Index Scan using labor_cloud_automation_run_attempt_labor_cloud_automation_run_d on labor_cloud_automation_run_attempt laborcloud0_ (cost=0.28..8.30 rows=1 width=41) (actual time=5.994..5.995 rows=3 loops=1)

  • Index Cond: (labor_cloud_automation_run_id = 532)
5. 0.024 0.024 ↑ 1.0 1 3

Index Only Scan using labor_cloud_automation_run_pkey on labor_cloud_automation_run laborcloud1_ (cost=0.28..8.29 rows=1 width=8) (actual time=0.008..0.008 rows=1 loops=3)

  • Index Cond: (id = 532)
  • Heap Fetches: 3