explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mDNeH

Settings
# exclusive inclusive rows x rows loops node
1. 0.017 0.962 ↓ 0.0 0 1

Delete on weekly_routine (cost=0.43..9.57 rows=1 width=12) (actual time=0.961..0.962 rows=0 loops=1)

  • Buffers: shared hit=5 read=2 dirtied=1
  • I/O Timings: read=0.918
2. 0.003 0.945 ↑ 1.0 1 1

Nested Loop (cost=0.43..9.57 rows=1 width=12) (actual time=0.944..0.945 rows=1 loops=1)

  • Join Filter: (weekly_routine.routine_id = routine.routine_id)
  • Buffers: shared hit=3 read=2
  • I/O Timings: read=0.918
3. 0.938 0.938 ↑ 1.0 1 1

Index Scan using weekly_routine_date_class_idx on weekly_routine (cost=0.43..8.45 rows=1 width=10) (actual time=0.937..0.938 rows=1 loops=1)

  • Index Cond: ((routine_date = '2016-10-10'::date) AND (class_id = 877,560))
  • Filter: (child_id = 8,190,841)
  • Buffers: shared hit=2 read=2
  • I/O Timings: read=0.918
4. 0.004 0.004 ↑ 5.0 1 1

Seq Scan on routine (cost=0.00..1.05 rows=5 width=10) (actual time=0.004..0.004 rows=1 loops=1)

  • Buffers: shared hit=1
Planning time : 0.869 ms
Execution time : 4,938.231 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint fk_weekly_routine_strategy_weekly_routine_id on weekly_routine 235.653 ms 1 235.653 ms
for constraint fk_weekly_routine_asset_weekly_routine_id on weekly_routine 548.049 ms 1 548.049 ms
for constraint fk_weekly_routine_careplan_answer_weekly_routine_id on weekly_routine 3,877.045 ms 1 3,877.045 ms
for constraint child_asset_rating_weekly_routine_asset_id on weekly_routine_asset 276.420 ms 1 276.420 ms