explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GIn5

Settings
# exclusive inclusive rows x rows loops node
1. 0.159 427,121.186 ↑ 1.0 938 1
→

Limit (cost=0.99..10,895.95 rows=938 width=12) (actual time=426,984.357..427,121.186 rows=938 loops=1)

  • Buffers: shared hit=2,314,709 read=922,573 dirtied=10,579 written=19,839
  • I/O Timings: read=410,239.965 write=5,652.583
2. 0.582 427,121.027 ↑ 239.4 938 1
→

Nested Loop (cost=0.99..2,607,880.61 rows=224,525 width=12) (actual time=426,984.355..427,121.027 rows=938 loops=1)

  • Buffers: shared hit=2,314,709 read=922,573 dirtied=10,579 written=19,839
  • I/O Timings: read=410,239.965 write=5,652.583
3. 427,056.185 427,056.185 ↑ 374.9 945 1
→

Index Scan using index_projects_on_last_repository_updated_at on public.projects (cost=0.56..2,385,901.54 rows=354,238 width=12) (actual time=426,973.191..427,056.185 rows=945 loops=1)

  • Filter: ((projects.repository_storage)::text = 'nfs-file21'::text)
  • Rows Removed by Filter: 3,229,466
  • Buffers: shared hit=2,311,838 read=922,531 dirtied=10,568 written=19,839
  • I/O Timings: read=410,200.237 write=5,652.583
4. 64.260 64.260 ↑ 1.0 1 945
→

Index Only Scan using idx_repository_states_on_last_repository_verification_ran_at on public.project_repository_states (cost=0.43..0.62 rows=1 width=4) (actual time=0.068..0.068 rows=1 loops=945)

  • Index Cond: (project_repository_states.project_id = projects.id)
  • Heap Fetches: 13
  • Filter: ((project_repository_states.last_repository_verification_ran_at IS NULL) OR (project_repository_states.last_repository_verification_ran_at <= '2019-11-19 11:02:56.610774+00'::timestamp with time zone))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=2,871 read=42 dirtied=11
  • I/O Timings: read=39.728