explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RUyZn

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 0.034 ↓ 3.0 3 1

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

2. 0.008 0.029 ↓ 3.0 3 1

Sort (cost=16.61..16.62 rows=1 width=41) (actual time=0.029..0.029 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.002 0.021 ↓ 3.0 3 1

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

4. 0.007 0.007 ↓ 3.0 3 1

Index Scan using labor_cloud_automation_run_attempt_labor_cloud_automation_run on labor_cloud_automation_run_attempt laborcloud0_ (cost=0.28..8.30 rows=1 width=41) (actual time=0.006..0.007 rows=3 loops=1)

  • Index Cond: (labor_cloud_automation_run_id = 532)
5. 0.012 0.012 ↑ 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.003..0.004 rows=1 loops=3)

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