explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lPKW : index_exists

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

Nested Loop (cost=1.12..7.75 rows=1 width=1,551) (actual time=0.147..0.223 rows=1 loops=1)

  • Join Filter: (ix.indrelid = t.oid)
  • Buffers: shared hit=20
2. 0.001 0.184 ↑ 1.0 1 1

Nested Loop (cost=0.84..7.43 rows=1 width=1,307) (actual time=0.109..0.184 rows=1 loops=1)

  • Buffers: shared hit=17
3. 0.002 0.072 ↑ 1.0 1 1

Nested Loop (cost=0.56..6.60 rows=1 width=1,104) (actual time=0.071..0.072 rows=1 loops=1)

  • Buffers: shared hit=6
4. 0.038 0.038 ↑ 1.0 1 1

Index Scan using pg_class_relname_nsp_index on pg_class i (cost=0.28..3.30 rows=1 width=248) (actual time=0.038..0.038 rows=1 loops=1)

  • Index Cond: (relname = 'tmp_index_on_project_id_partial_with_prometheus_services'::name)
  • Buffers: shared hit=3
5. 0.032 0.032 ↑ 1.0 1 1

Index Scan using pg_index_indexrelid_index on pg_index ix (cost=0.28..3.29 rows=1 width=860) (actual time=0.032..0.032 rows=1 loops=1)

  • Index Cond: (indexrelid = i.oid)
  • Buffers: shared hit=3
6. 0.111 0.111 ↑ 1.0 1 1

Index Scan using pg_attribute_relid_attnum_index on pg_attribute a (cost=0.29..0.82 rows=1 width=203) (actual time=0.037..0.111 rows=1 loops=1)

  • Index Cond: (attrelid = ix.indrelid)
  • Filter: (attnum = ANY ((ix.indkey)::smallint[]))
  • Rows Removed by Filter: 32
  • Buffers: shared hit=11
7. 0.034 0.034 ↑ 1.0 1 1

Index Scan using pg_class_oid_index on pg_class t (cost=0.28..0.31 rows=1 width=248) (actual time=0.034..0.034 rows=1 loops=1)

  • Index Cond: (oid = a.attrelid)
  • Filter: ((relkind = 'r'::"char") AND (relname = 'services'::name))
  • Buffers: shared hit=3
Planning time : 13.861 ms
Execution time : 0.419 ms