explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7T7E

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.090 ↑ 1.0 1 1

Limit (cost=0.41..772.81 rows=1 width=161) (actual time=0.090..0.090 rows=1 loops=1)

  • Output: id, created_at, updated_at, project_id, active, encrypted_token, encrypted_token_iv, endpoint_identifier, name
  • Buffers: shared hit=20
2. 0.089 0.089 ↑ 1.0 1 1

Index Scan using index_http_integrations_on_active_and_project_and_endpoint on public.alert_management_http_integrations (cost=0.41..772.81 rows=1 width=161) (actual time=0.089..0.089 rows=1 loops=1)

  • Output: id, created_at, updated_at, project_id, active, encrypted_token, encrypted_token_iv, endpoint_identifier, name
  • Index Cond: ((alert_management_http_integrations.project_id = '4'::bigint) AND (alert_management_http_integrations.endpoint_identifier = '72e6ed9e7bf06d1b'::text))
  • Buffers: shared hit=20
Planning time : 0.049 ms
Execution time : 0.100 ms