explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AYn

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

Delete on df_scenario (cost=0.00..1.52 rows=1 width=6) (actual time=0.036..0.036 rows=0 loops=1)

2. 0.018 0.018 ↑ 1.0 1 1

Seq Scan on df_scenario (cost=0.00..1.52 rows=1 width=6) (actual time=0.014..0.018 rows=1 loops=1)

  • Filter: ((df_scenario_uid)::text = 'f0c383d9-f672-4eb9-917a-db9a802f9e06'::text)
  • Rows Removed by Filter: 38
Planning time : 0.057 ms
Execution time : 68,937.619 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint fk_df_usage_2_df_scenario 51,330.296 ms 1 51,330.296 ms
for constraint fk_df_usage_archive_2_df_scenario 17,606.506 ms 1 17,606.506 ms
for constraint fk_df_scenario_2_df_scenario_audit 0.387 ms 1 0.387 ms
for constraint fk_df_scenario_usage_filter_2_df_scenario 0.207 ms 1 0.207 ms
for constraint fk_df_rightsholder_discrepancy_2_df_scenario 0.164 ms 1 0.164 ms