explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1RZW

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 packages_packages 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))
  • Buffers: shared hit=4
Planning time : 0.651 ms
Execution time : 0.062 ms