explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pgZH

Settings
# exclusive inclusive rows x rows loops node
1. 0.078 0.176 ↓ 0.0 0 1

Delete on element (cost=30.81..1,670.89 rows=2,356,294 width=12) (actual time=0.176..0.176 rows=0 loops=1)

  • Buffers: shared hit=61
2. 0.012 0.098 ↑ 235,629.4 10 1

Nested Loop (cost=30.81..1,670.89 rows=2,356,294 width=12) (actual time=0.059..0.098 rows=10 loops=1)

  • Buffers: shared hit=41
3. 0.011 0.026 ↑ 20.0 10 1

HashAggregate (cost=30.38..32.38 rows=200 width=14) (actual time=0.023..0.026 rows=10 loops=1)

  • Group Key: tt_multimedia.id
  • Buffers: shared hit=1
4. 0.015 0.015 ↑ 163.0 10 1

Seq Scan on tt_multimedia (cost=0.00..26.30 rows=1,630 width=14) (actual time=0.013..0.015 rows=10 loops=1)

  • Buffers: shared hit=1
5. 0.060 0.060 ↑ 1.0 1 10

Index Scan using element__pkey on element (cost=0.43..8.18 rows=1 width=14) (actual time=0.005..0.006 rows=1 loops=10)

  • Index Cond: (id = tt_multimedia.id)
  • Buffers: shared hit=40
Planning time : 0.213 ms
Execution time : 202.760 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint attribute__id__fk on element 0.937 ms 10 0.094 ms
for constraint category__id__fk on element 0.906 ms 10 0.091 ms
for constraint content__id__fk on element 0.994 ms 10 0.099 ms
for constraint elt_nomencl__element_id__fk on element 0.917 ms 10 0.092 ms
for constraint item_link__id__fk on element 0.752 ms 10 0.075 ms
for constraint item_link_element__element_id__fk on element 1.252 ms 10 0.125 ms
for constraint multimedia__id__fk on element 0.732 ms 10 0.073 ms
for constraint nomenclature__id__fk on element 0.819 ms 10 0.082 ms
for constraint pointer__id__fk on element 0.868 ms 10 0.087 ms
for constraint portal__id__fk on element 0.827 ms 10 0.083 ms
for constraint portal_element__element_id__fk on element 74.516 ms 10 7.452 ms
for constraint portal_model__id__fk on element 1.575 ms 10 0.158 ms
for constraint redirection__id__fk on element 1.142 ms 10 0.114 ms
for constraint redirection__target_id__fk on element 1.966 ms 10 0.197 ms
for constraint series__id__fk on element 0.827 ms 10 0.083 ms
for constraint series_set_static__element_id__fk on element 104.015 ms 10 10.402 ms
for constraint tag__element_id__fk on element 1.529 ms 10 0.153 ms
for constraint element_value__element_id__fk on element 1.082 ms 10 0.108 ms
update_element on element 5.203 ms 10 0.520 ms
for constraint series_set_dynamic_constraint__multimedia_id__fk on multimedia 1.008 ms 10 0.101 ms
for constraint element_value__multimedia_id__fk on multimedia 0.520 ms 10 0.052 ms