explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iegY

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 69,479.964 ↓ 0.0 0 1

Delete on receiver_status rs (cost=959,504.18..959,553.42 rows=1 width=6) (actual time=69,479.964..69,479.964 rows=0 loops=1)

  • Buffers: shared hit=2,795,711 read=1,685,511 dirtied=32,841 written=12,903
2.          

Initplan (for Delete)

3. 3,076.721 3,076.721 ↑ 8.1 403,573 1

Seq Scan on receivers (cost=0.00..959,503.61 rows=3,257,970 width=8) (actual time=0.143..3,076.721 rows=403,573 loops=1)

  • Filter: (deviceid !~~* 'con%'::text)
  • Rows Removed by Filter: 54,022
  • Buffers: shared hit=100,359 read=813,252 dirtied=236 written=172
4. 69,474.485 69,474.485 ↓ 412.0 412 1

Index Scan using receiver_status_idx12 on receiver_status rs (cost=0.57..49.81 rows=1 width=6) (actual time=3,562.077..69,474.485 rows=412 loops=1)

  • Index Cond: ((receiverkey = ANY ($0)) AND (statusupdatetime < '2018-12-25 00:02:00+01'::timestamp with time zone))
  • Buffers: shared hit=2,794,887 read=1,685,511 dirtied=32,839 written=12,903
Planning time : 5.994 ms
Execution time : 69,492.630 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint link2 on receiver_status 8.155 ms 412 0.020 ms
for constraint link2 on receiver_status 4.035 ms 412 0.010 ms
for constraint link2 on receiver_location_tracking 0.100 ms 4 0.025 ms