explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 682w

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 2,858.046 ↑ 1.0 1 1

Result (cost=1.24..1.25 rows=1 width=4) (actual time=2,858.046..2,858.046 rows=1 loops=1)

  • Buffers: shared hit=3,362 read=2,989 dirtied=7
  • I/O Timings: read=2,815.458
2.          

Initplan (for Result)

3. 0.002 2,858.038 ↑ 1.0 1 1

Limit (cost=0.42..1.24 rows=1 width=4) (actual time=2,858.038..2,858.038 rows=1 loops=1)

  • Buffers: shared hit=3,362 read=2,989 dirtied=7
  • I/O Timings: read=2,815.458
4. 2,858.036 2,858.036 ↑ 70,636.0 1 1

Index Scan using services_pkey on public.services (cost=0.42..57,325.34 rows=70,636 width=4) (actual time=2,858.036..2,858.036 rows=1 loops=1)

  • Index Cond: (services.id IS NOT NULL)
  • Filter: (services.active AND (services.project_id IS NOT NULL) AND ((services.type)::text = 'JiraService'::text))
  • Rows Removed by Filter: 30,209
  • Buffers: shared hit=3,362 read=2,989 dirtied=7
  • I/O Timings: read=2,815.458