explain.depesz.com

PostgreSQL's explain analyze made readable

Result: efp3

Settings
# exclusive inclusive rows x rows loops node
1. 0.051 602,012.093 ↑ 1.0 20 1

Limit (cost=0.56..21,014.14 rows=20 width=755) (actual time=81,450.080..602,012.093 rows=20 loops=1)

  • Buffers: shared hit=2399256 read=1036285 dirtied=11118
  • I/O Timings: read=289170.150
2. 601,916.228 602,012.042 ↑ 2,833.8 20 1

Index Scan using index_projects_on_created_at_and_id on public.projects (cost=0.56..59,549,326.69 rows=56,677 width=755) (actual time=81,450.078..602,012.042 rows=20 loops=1)

  • Filter: ((NOT projects.pending_delete) AND (projects.visibility_level = 10) AND ((alternatives: SubPlan 1 or hashed SubPlan 2) OR (projects.visibility_level = 10)))
  • Rows Removed by Filter: 3282027
  • Buffers: shared hit=2399256 read=1036285 dirtied=11118
  • I/O Timings: read=289170.150
3.          

SubPlan (for Index Scan)

4. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using index_project_authorizations_on_user_id_project_id_access_level on public.project_authorizations (cost=0.57..4.59 rows=1 width=0) (actual time=0.000..0.000 rows=0 loops=0)

  • Index Cond: ((project_authorizations.user_id = 5297955) AND (project_authorizations.project_id = projects.id))
  • Heap Fetches: 0
5. 95.814 95.814 ↓ 7.4 2,377 1

Index Only Scan using index_project_authorizations_on_user_id_project_id_access_level on public.project_authorizations project_authorizations_1 (cost=0.57..14.20 rows=322 width=4) (actual time=15.013..95.814 rows=2,377 loops=1)

  • Index Cond: (project_authorizations_1.user_id = 5297955)
  • Heap Fetches: 15
  • Buffers: shared hit=155 read=7 dirtied=1
  • I/O Timings: read=13.039