explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dBx9

Settings
# exclusive inclusive rows x rows loops node
1. 324.162 1,152.791 ↑ 20.0 60 1

HashAggregate (cost=1,393,703.66..1,393,718.66 rows=1,200 width=14) (actual time=1,152.752..1,152.791 rows=60 loops=1)

  • Group Key: date(calendar.entry), vulnerabilities.severity
  • Buffers: shared hit=28,019 read=331
  • I/O Timings: read=9.615
2. 282.588 828.629 ↑ 33.3 856,220 1

Nested Loop (cost=0.44..1,179,572.17 rows=28,550,865 width=6) (actual time=0.362..828.629 rows=856,220 loops=1)

  • Buffers: shared hit=28,019 read=331
  • I/O Timings: read=9.615
3. 0.031 0.031 ↑ 100.0 10 1

Function Scan on generate_series calendar (cost=0.01..10.01 rows=1,000 width=8) (actual time=0.016..0.031 rows=10 loops=1)

4. 546.010 546.010 ↓ 3.0 85,622 10

Index Scan using i2 on public.vulnerabilities (cost=0.43..822.67 rows=28,551 width=26) (actual time=0.056..54.601 rows=85,622 loops=10)

  • Index Cond: ((vulnerabilities.project_id = 10,300,671) AND (vulnerabilities.created_at <= calendar.entry))
  • Filter: (((vulnerabilities.dismissed_at IS NULL) OR (vulnerabilities.dismissed_at > calendar.entry)) AND ((vulnerabilities.resolved_at IS NULL) OR (vulnerabilities.resolved_at > calendar.entry)))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=28,019 read=331
  • I/O Timings: read=9.615