explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LTQF

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.038 ↓ 0.0 0 1

Update on ctt_object_applications (cost=677.09..21,303.86 rows=8,792 width=34) (actual time=0.038..0.038 rows=0 loops=1)

2. 0.003 0.034 ↓ 0.0 0 1

Nested Loop (cost=677.09..21,303.86 rows=8,792 width=34) (actual time=0.034..0.034 rows=0 loops=1)

3. 0.012 0.031 ↓ 0.0 0 1

Hash Join (cost=677.09..20,646.69 rows=869 width=16) (actual time=0.031..0.031 rows=0 loops=1)

  • Hash Cond: (op.idpro = k.idkey)
4. 0.008 0.008 ↑ 1,042,030.0 1 1

Seq Scan on objpro op (cost=0.00..16,053.30 rows=1,042,030 width=14) (actual time=0.008..0.008 rows=1 loops=1)

5. 0.003 0.011 ↓ 0.0 0 1

Hash (cost=672.00..672.00 rows=407 width=10) (actual time=0.011..0.011 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 0kB
6. 0.008 0.008 ↓ 0.0 0 1

Index Scan using keys_classidproptyp on keys k (cost=0.00..672.00 rows=407 width=10) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (keyclass = 13040)
7. 0.000 0.000 ↓ 0.0 0

Index Scan using idx1_obj_app on ctt_object_applications (cost=0.00..0.67 rows=9 width=22) (never executed)

  • Index Cond: (object_id = op.idobj)
  • Filter: (properties = 0)