explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EW7b

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 6.185 ↑ 1.0 1 1

Aggregate (cost=915.71..915.72 rows=1 width=4) (actual time=6.185..6.185 rows=1 loops=1)

  • Buffers: shared hit=1 read=4 dirtied=1
  • I/O Timings: read=4.331
2. 0.001 6.182 ↓ 0.0 0 1

Nested Loop (cost=0.43..914.58 rows=452 width=4) (actual time=6.182..6.182 rows=0 loops=1)

  • Buffers: shared hit=1 read=4 dirtied=1
  • I/O Timings: read=4.331
3. 6.181 6.181 ↓ 0.0 0 1

Seq Scan on public.project_incident_management_settings (cost=0.00..29.05 rows=452 width=4) (actual time=6.181..6.181 rows=0 loops=1)

  • Filter: project_incident_management_settings.sla_timer
  • Rows Removed by Filter: 906
  • Buffers: shared hit=1 read=4 dirtied=1
  • I/O Timings: read=4.331
4. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using projects_pkey on public.projects (cost=0.43..1.96 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=0)

  • Index Cond: (projects.id = project_incident_management_settings.project_id)
  • Heap Fetches: 0