explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pnhh

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 17.598 ↓ 0.0 0 1

Update on ctt_object_applications (cost=21,334.77..21,646.63 rows=7,316 width=40) (actual time=17.598..17.598 rows=0 loops=1)

2. 0.004 17.580 ↓ 0.0 0 1

Nested Loop (cost=21,334.77..21,646.63 rows=7,316 width=40) (actual time=17.580..17.580 rows=0 loops=1)

3. 0.008 17.576 ↓ 0.0 0 1

HashAggregate (cost=21,334.77..21,338.84 rows=407 width=26) (actual time=17.576..17.576 rows=0 loops=1)

4. 0.005 17.568 ↓ 0.0 0 1

Nested Loop (cost=677.09..21,303.86 rows=12,366 width=26) (actual time=17.568..17.568 rows=0 loops=1)

5. 0.028 17.563 ↓ 0.0 0 1

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

  • Hash Cond: (op.idpro = k.idkey)
6. 0.093 0.093 ↑ 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.093..0.093 rows=1 loops=1)

7. 0.005 17.442 ↓ 0.0 0 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 0kB
8. 17.437 17.437 ↓ 0.0 0 1

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

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

Index Scan using idx1_obj_app on ctt_object_applications (cost=0.00..0.64 rows=12 width=10) (never executed)

  • Index Cond: (object_id = op.idobj)
10. 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.idpro)
  • Filter: (properties = 0)