explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7xof

Settings
# exclusive inclusive rows x rows loops node
1. 0.021 0.084 ↓ 0.0 0 1

ModifyTable on public.vulnerabilities (cost=0.43..140.02 rows=93 width=295) (actual time=0.084..0.084 rows=0 loops=1)

  • Buffers: shared hit=3
2. 0.063 0.063 ↓ 0.0 0 1

Index Scan using index_vulnerabilities_on_project_id on public.vulnerabilities (cost=0.43..140.02 rows=93 width=295) (actual time=0.063..0.063 rows=0 loops=1)

  • Index Cond: (vulnerabilities.project_id = 1)
  • Filter: (vulnerabilities.id <> 1)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=3