explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jRaJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.026 0.026 ↑ 1.0 1 1

Index Scan using index_packages_packages_on_project_id_and_package_type on public.packages_packages (cost=0.42..3.45 rows=1 width=84) (actual time=0.025..0.026 rows=1 loops=1)

  • Index Cond: ((packages_packages.project_id = 20,760,965) AND (packages_packages.package_type = 5))
  • Filter: ((packages_packages.version IS NOT NULL) AND ((packages_packages.name)::text = 'mypypipackage'::text))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=4