explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ijvj

Settings
# exclusive inclusive rows x rows loops node
1. 0.100 0.190 ↓ 0.0 0 1

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

  • Buffers: shared hit=61
2. 0.006 0.090 ↑ 235,629.4 10 1

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

  • Buffers: shared hit=41
3. 0.007 0.024 ↑ 20.0 10 1

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

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

Seq Scan on tt_multimedia (cost=0.00..26.30 rows=1,630 width=14) (actual time=0.015..0.017 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.006..0.006 rows=1 loops=10)

  • Index Cond: (id = tt_multimedia.id)
  • Buffers: shared hit=40
Planning time : 0.163 ms
Execution time : 18.207 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint attribute__id__fk on element 0.278 ms 10 0.028 ms
for constraint category__id__fk on element 8.149 ms 10 0.815 ms
for constraint content__id__fk on element 0.272 ms 10 0.027 ms
for constraint elt_nomencl__element_id__fk on element 0.218 ms 10 0.022 ms
for constraint item_link__id__fk on element 0.203 ms 10 0.020 ms
for constraint item_link_element__element_id__fk on element 0.622 ms 10 0.062 ms
for constraint multimedia__id__fk on element 0.522 ms 10 0.052 ms
for constraint nomenclature__id__fk on element 1.715 ms 10 0.171 ms
for constraint pointer__id__fk on element 0.436 ms 10 0.044 ms
for constraint portal__id__fk on element 0.233 ms 10 0.023 ms
for constraint portal_element__element_id__fk on element 0.986 ms 10 0.099 ms
for constraint portal_model__id__fk on element 0.205 ms 10 0.020 ms
for constraint redirection__id__fk on element 0.166 ms 10 0.017 ms
for constraint redirection__target_id__fk on element 0.863 ms 10 0.086 ms
for constraint series__id__fk on element 0.223 ms 10 0.022 ms
for constraint series_set_static__element_id__fk on element 0.639 ms 10 0.064 ms
for constraint tag__element_id__fk on element 0.169 ms 10 0.017 ms
for constraint element_value__element_id__fk on element 0.241 ms 10 0.024 ms
update_element on element 1.144 ms 10 0.114 ms
for constraint series_set_dynamic_constraint__multimedia_id__fk on multimedia 0.216 ms 10 0.022 ms
for constraint element_value__multimedia_id__fk on multimedia 0.372 ms 10 0.037 ms