explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XTuj

Settings
# exclusive inclusive rows x rows loops node
1. 0.028 0.028 ↑ 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.027..0.028 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 (regexp_replace((packages_packages.name)::text, '[-_.]+'::text, '-'::text, 'g'::text) = 'mypypipackage'::text))
  • Buffers: shared hit=4
Planning time : 0.456 ms
Execution time : 0.049 ms