explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vLSF

Settings
# exclusive inclusive rows x rows loops node
1. 0.052 2.085 ↑ 1.0 1 1

Aggregate (cost=17.09..17.10 rows=1 width=16) (actual time=2.084..2.085 rows=1 loops=1)

2. 0.068 2.033 ↓ 335.0 335 1

Unique (cost=17.05..17.06 rows=1 width=92) (actual time=1.944..2.033 rows=335 loops=1)

3. 0.233 1.965 ↓ 392.0 392 1

Sort (cost=17.05..17.05 rows=1 width=92) (actual time=1.944..1.965 rows=392 loops=1)

  • Sort Key: api_host.system_uuid, api_host.display_name, api_host.rhel_version, api_host.stale_at, api_host.stale_warn_at
  • Sort Method: quicksort Memory: 80kB
4. 0.188 1.732 ↓ 392.0 392 1

Nested Loop (cost=0.99..17.04 rows=1 width=92) (actual time=0.036..1.732 rows=392 loops=1)

5. 0.368 0.368 ↓ 392.0 392 1

Index Scan using api_upload_current_account_index on api_upload (cost=0.57..8.59 rows=1 width=16) (actual time=0.028..0.368 rows=392 loops=1)

  • Index Cond: ((current = true) AND (current = true) AND ((account)::text = '540155'::text))
  • Filter: (current AND current)
6. 1.176 1.176 ↑ 1.0 1 392

Index Scan using api_host_pkey on api_host (cost=0.43..8.45 rows=1 width=60) (actual time=0.003..0.003 rows=1 loops=392)

  • Index Cond: (system_uuid = api_upload.host_id)
Planning time : 0.435 ms
Execution time : 2.128 ms