explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mmUg

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 3.623 ↓ 0.0 0 1

Nested Loop (cost=0.55..6.61 rows=1 width=4) (actual time=3.623..3.623 rows=0 loops=1)

  • Buffers: shared hit=3 read=4
  • I/O Timings: read=3.549
2. 3.623 3.623 ↓ 0.0 0 1

Index Scan using idx_packages_packages_on_project_id_name_version_package_type on public.packages_packages (cost=0.42..4.45 rows=1 width=8) (actual time=3.623..3.623 rows=0 loops=1)

  • Index Cond: ((packages_packages.project_id = 1) AND ((packages_packages.name)::text = 'foo'::text) AND ((packages_packages.version)::text = '1.0'::text) AND (packages_packages.package_type = 3))
  • Filter: (packages_packages.id <> 1)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=3 read=4
  • I/O Timings: read=3.549
3. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using index_packages_conan_metadata_on_package_id_username_channel on public.packages_conan_metadata (cost=0.14..2.16 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=0)

  • Index Cond: ((packages_conan_metadata.package_id = packages_packages.id) AND (packages_conan_metadata.package_username = 'mygroup+myorg'::text) AND (packages_conan_metadata.package_channel = 'stable'::text))
  • Heap Fetches: 0