explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ELw2

Settings
# exclusive inclusive rows x rows loops node
1. 3.818 81,544.997 ↓ 0.0 0 1

Insert on public.project_pages_metadata (cost=1.61..53,021.19 rows=1,000 width=9) (actual time=81,544.997..81,544.997 rows=0 loops=1)

  • Buffers: shared hit=9488256 read=139940 dirtied=34755 written=35879
2. 0.008 81,541.179 ↑ 1,000.0 1 1

Subquery Scan on *SELECT* (cost=1.61..53,021.19 rows=1,000 width=9) (actual time=76,366.478..81,541.179 rows=1 loops=1)

  • Buffers: shared hit=9488249 read=139936 dirtied=34753 written=35879
3. 0.003 81,541.171 ↑ 1,000.0 1 1

Limit (cost=1.61..53,008.69 rows=1,000 width=5) (actual time=76,366.472..81,541.171 rows=1 loops=1)

  • Buffers: shared hit=9488249 read=139936 dirtied=34753 written=35879
4. 3,812.186 81,541.168 ↑ 15,837.0 1 1

Merge Join (cost=1.61..839,474.75 rows=15,837 width=5) (actual time=76,366.470..81,541.168 rows=1 loops=1)

  • Buffers: shared hit=9488249 read=139936 dirtied=34753 written=35879
5. 45,606.721 45,606.721 ↑ 1.0 11,248,024 1

Index Only Scan using projects_pkey on public.projects (cost=0.43..281,737.98 rows=11,249,210 width=4) (actual time=3.616..45,606.721 rows=11,248,024 loops=1)

  • Heap Fetches: 625902
  • Buffers: shared hit=9024275 read=71386 dirtied=22447 written=15931
6. 32,119.604 32,119.604 ↓ 1.0 11,248,023 1

Index Only Scan using index_project_pages_metadata_on_project_id on public.project_pages_metadata project_pages_metadata_1 (cost=0.43..318,761.53 rows=11,233,373 width=8) (actual time=0.046..32,119.604 rows=11,248,023 loops=1)

  • Heap Fetches: 1982779
  • Buffers: shared hit=463974 read=68547 dirtied=12306 written=19948
7.          

SubPlan (for Merge Join)

8. 0.007 2.657 ↓ 0.0 0 1

Limit (cost=0.43..4.45 rows=1 width=1) (actual time=2.657..2.657 rows=0 loops=1)

  • Buffers: shared read=3
9. 2.650 2.650 ↓ 0.0 0 1

Index Only Scan using index_ci_builds_on_project_id_for_successfull_pages_deploy on public.ci_builds (cost=0.43..4.45 rows=1 width=1) (actual time=2.650..2.650 rows=0 loops=1)

  • Index Cond: (ci_builds.project_id = projects.id)
  • Heap Fetches: 0
  • Buffers: shared read=3