explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bmM1

Settings
# exclusive inclusive rows x rows loops node
1. 10.843 964.915 ↓ 6.9 710 1

GroupAggregate (cost=20,269.99..20,271.79 rows=103 width=8) (actual time=945.882..964.915 rows=710 loops=1)

2. 19.204 954.072 ↓ 78.8 8,116 1

Sort (cost=20,269.99..20,270.25 rows=103 width=8) (actual time=945.849..954.072 rows=8,116 loops=1)

  • Sort Key: kp.idparent
  • Sort Method: quicksort Memory: 573kB
3. 52.370 934.868 ↓ 78.8 8,116 1

Nested Loop (cost=10,482.47..20,266.55 rows=103 width=8) (actual time=789.875..934.868 rows=8,116 loops=1)

4. 30.055 850.030 ↓ 116.0 8,117 1

Nested Loop (cost=10,482.47..20,138.65 rows=70 width=8) (actual time=789.857..850.030 rows=8,117 loops=1)

5. 4.445 794.175 ↑ 1.7 3,225 1

Hash Join (cost=10,482.47..13,401.93 rows=5,348 width=4) (actual time=789.826..794.175 rows=3,225 loops=1)

  • Hash Cond: (tc.idtyp = k2.objtyp)
6. 0.235 0.235 ↓ 6.0 126 1

Index Only Scan using idx_typcat on typcat tc (cost=0.00..43.95 rows=21 width=4) (actual time=0.018..0.235 rows=126 loops=1)

  • Index Cond: (idcatparent = 10001)
  • Heap Fetches: 126
7. 407.849 789.495 ↑ 1.0 293,278 1

Hash (cost=6,815.54..6,815.54 rows=293,354 width=8) (actual time=789.495..789.495 rows=293,278 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 11457kB
8. 381.646 381.646 ↑ 1.0 293,278 1

Seq Scan on keys k2 (cost=0.00..6,815.54 rows=293,354 width=8) (actual time=0.006..381.646 rows=293,278 loops=1)

9. 25.800 25.800 ↓ 3.0 3 3,225

Index Scan using acc_cle on acc a (cost=0.00..1.25 rows=1 width=8) (actual time=0.003..0.008 rows=3 loops=3,225)

  • Index Cond: (idcle = k2.idkey)
  • Filter: ((accknd = ANY ('{0,4096,262144,1048576}'::integer[])) AND ((prop & 65536) = 0))
  • Rows Removed by Filter: 0
10. 32.468 32.468 ↑ 1.0 1 8,117

Index Scan using idx_keyparkey on keypar kp (cost=0.00..1.82 rows=1 width=8) (actual time=0.003..0.004 rows=1 loops=8,117)

  • Index Cond: (idkey = a.idclr)