explain.depesz.com

PostgreSQL's explain analyze made readable

Result: trhc

Settings
# exclusive inclusive rows x rows loops node
1. 360.339 977.301 ↑ 20.0 60 1

HashAggregate (cost=2,083,844.86..2,083,859.86 rows=1,200 width=14) (actual time=977.277..977.301 rows=60 loops=1)

  • Group Key: date(calendar.entry), vulnerabilities.severity
  • Buffers: shared hit=3,801
2. 461.228 616.962 ↑ 33.3 856,220 1

Nested Loop (cost=0.44..1,870,049.95 rows=28,505,989 width=6) (actual time=0.180..616.962 rows=856,220 loops=1)

  • Buffers: shared hit=3,801
3. 0.024 0.024 ↑ 100.0 10 1

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

4. 113.010 155.710 ↑ 1.0 85,870 10

Materialize (cost=0.43..71,230.94 rows=86,388 width=26) (actual time=0.003..15.571 rows=85,870 loops=10)

  • Buffers: shared hit=3,801
5. 42.700 42.700 ↑ 1.0 85,870 1

Index Scan using index_vulnerabilities_on_project_id on public.vulnerabilities (cost=0.43..70,799.00 rows=86,388 width=26) (actual time=0.027..42.700 rows=85,870 loops=1)

  • Index Cond: (vulnerabilities.project_id = 10,300,671)
  • Buffers: shared hit=3,801