explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SaMG

Settings
# exclusive inclusive rows x rows loops node
1. 104.344 134.460 ↓ 0.0 0 1

Delete on place (cost=6.11..3,415.26 rows=5,410 width=12) (actual time=134.460..134.460 rows=0 loops=1)

  • Buffers: shared hit=72620
2. 11.203 30.116 ↓ 6.5 35,037 1

Hash Semi Join (cost=6.11..3,415.26 rows=5,410 width=12) (actual time=0.061..30.116 rows=35,037 loops=1)

  • Hash Cond: (place.format_id = format.id)
  • Buffers: shared hit=2546
3. 18.873 18.873 ↓ 1.0 65,239 1

Seq Scan on place (cost=0.00..3,181.39 rows=63,839 width=14) (actual time=0.007..18.873 rows=65,239 loops=1)

  • Buffers: shared hit=2543
4. 0.010 0.040 ↓ 4.1 41 1

Hash (cost=5.98..5.98 rows=10 width=14) (actual time=0.040..0.040 rows=41 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=3
5. 0.030 0.030 ↓ 4.1 41 1

Seq Scan on format (cost=0.00..5.98 rows=10 width=14) (actual time=0.008..0.030 rows=41 loops=1)

  • Filter: ((chain_id = 0) AND (channel_id = 35))
  • Rows Removed by Filter: 173
  • Buffers: shared hit=3
Planning time : 0.164 ms
Execution time : 2,285,374.046 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint place_attributes_place_id_fkey 125,041.431 ms 35037 3.569 ms
for constraint product_place_scope_place_id_fkey 976.496 ms 35037 0.028 ms
for constraint place_attributes_place_id_fkey 124,857.283 ms 35037 3.564 ms
for constraint product_place_scope_place_id_fkey 950.472 ms 35037 0.027 ms
for constraint place_attributes_place_id_fkey 124,249.481 ms 35037 3.546 ms
for constraint product_place_scope_place_id_fkey 958.266 ms 35037 0.027 ms
for constraint place_attributes_place_id_fkey 124,060.994 ms 35037 3.541 ms
for constraint product_place_scope_place_id_fkey 948.881 ms 35037 0.027 ms
for constraint place_attributes_place_id_fkey 67,015.834 ms 35037 1.913 ms
for constraint product_place_scope_place_id_fkey 826.270 ms 35037 0.024 ms
for constraint place_attributes_place_id_fkey 116,026.120 ms 35037 3.312 ms
for constraint product_place_scope_place_id_fkey 927.065 ms 35037 0.026 ms
for constraint place_attributes_place_id_fkey 116,377.011 ms 35037 3.322 ms
for constraint product_place_scope_place_id_fkey 936.227 ms 35037 0.027 ms
for constraint place_attributes_place_id_fkey 116,065.254 ms 35037 3.313 ms
for constraint product_place_scope_place_id_fkey 956.115 ms 35037 0.027 ms
for constraint place_attributes_place_id_fkey 115,897.267 ms 35037 3.308 ms
for constraint product_place_scope_place_id_fkey 939.126 ms 35037 0.027 ms
for constraint place_attributes_place_id_fkey 116,475.886 ms 35037 3.324 ms
for constraint product_place_scope_place_id_fkey 931.470 ms 35037 0.027 ms
for constraint place_attributes_place_id_fkey 115,132.839 ms 35037 3.286 ms
for constraint product_place_scope_place_id_fkey 359,495.362 ms 35037 10.260 ms
for constraint place_attributes_place_id_fkey 116,898.765 ms 35037 3.336 ms
for constraint product_place_scope_place_id_fkey 983.810 ms 35037 0.028 ms
for constraint place_attributes_place_id_fkey 110,234.707 ms 35037 3.146 ms
for constraint product_place_scope_place_id_fkey 965.235 ms 35037 0.028 ms
for constraint place_attributes_place_id_fkey 106,773.707 ms 35037 3.047 ms
for constraint product_place_scope_place_id_fkey 210,448.103 ms 35037 6.006 ms
for constraint place_attributes_place_id_fkey 107,457.204 ms 35037 3.067 ms
for constraint product_place_scope_place_id_fkey 1,023.583 ms 35037 0.029 ms