explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WHCO : count license scanning

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

Aggregate (cost=13,528,072.87..13,528,072.88 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Index Only Scan using index_ci_builds_on_commit_id_and_type_and_name_and_ref on ci_builds (cost=0.70..13,528,066.47 rows=2,558 width=0) (actual rows= loops=)

  • Index Cond: ((type = 'Ci::Build'::text) AND (name = 'license_scanning'::text))