explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Hgz8

Settings
# exclusive inclusive rows x rows loops node
1. 0.141 8.666 ↑ 1.0 1 1

Aggregate (cost=38.94..38.95 rows=1 width=8) (actual time=8.665..8.666 rows=1 loops=1)

  • Buffers: shared read=8 dirtied=2
  • I/O Timings: read=5.613
2. 8.525 8.525 ↓ 1.0 447 1

Seq Scan on public.jira_imports (cost=0.00..37.83 rows=445 width=4) (actual time=1.783..8.525 rows=447 loops=1)

  • Filter: (jira_imports.status = 4)
  • Rows Removed by Filter: 21
  • Buffers: shared read=8 dirtied=2
  • I/O Timings: read=5.613