explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zYu

Settings
# exclusive inclusive rows x rows loops node
1. 2,770.388 2,919.922 ↓ 0.0 0 1

Delete on tblevents (cost=0.56..6,680.10 rows=40,280 width=6) (actual time=2,919.922..2,919.922 rows=0 loops=1)

2. 149.534 149.534 ↓ 11.2 450,692 1

Index Scan using ix_events_timestamp on tblevents (cost=0.56..6,680.10 rows=40,280 width=6) (actual time=0.013..149.534 rows=450,692 loops=1)

  • Index Cond: ((evntimestamp >= '2020-08-01 21:00:00'::timestamp without time zone) AND (evntimestamp <= '2020-08-11 21:00:00'::timestamp without time zone))
Total runtime : 358,883.386 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint fk_eventextra_events 77,864.048 ms 450692 0.173 ms
for constraint fk_extradata_events 262,894.786 ms 450692 0.583 ms
for constraint fk_images_events 14,997.007 ms 450692 0.033 ms