explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ARL7

Settings
# exclusive inclusive rows x rows loops node
1. 0.019 957.839 ↑ 1.0 1 1

Limit (cost=1,480.47..1,495.27 rows=1 width=8) (actual time=957.839..957.839 rows=1 loops=1)

  • Buffers: shared hit=637 read=971
  • I/O Timings: read=917.190
2. 14.927 957.820 ↑ 52.9 101 1

Unique (cost=0.43..79,123.27 rows=5,346 width=8) (actual time=0.056..957.820 rows=101 loops=1)

  • Buffers: shared hit=637 read=971
  • I/O Timings: read=917.190
3. 942.893 942.893 ↑ 20.7 134,338 1

Index Only Scan using index_vulnerabilities_on_project_id on public.vulnerabilities (cost=0.43..72,160.16 rows=2,785,242 width=8) (actual time=0.054..942.893 rows=134,338 loops=1)

  • Index Cond: (vulnerabilities.project_id >= 1)
  • Heap Fetches: 0
  • Buffers: shared hit=637 read=971
  • I/O Timings: read=917.190