explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xOj4

Settings
# exclusive inclusive rows x rows loops node
1. 0.263 2,800.292 ↓ 0.0 0 1

Delete on input_data (cost=0.00..595,489.98 rows=100 width=6) (actual time=2,800.292..2,800.292 rows=0 loops=1)

2. 2,800.029 2,800.029 ↑ 1.0 100 1

Seq Scan on input_data (cost=0.00..595,489.98 rows=100 width=6) (actual time=0.384..2,800.029 rows=100 loops=1)

  • Filter: (batch_id = ANY ('{19814,19823,19847,19865,19868,19870,19879,19889,19898,19899,19907,19908,19923,19931,19939,19947,19955,19963,19971,19979,19987,19995,20003,20011,20018,20025,20030,20035,20040,20045,20050,20055,20060,20065,20070,20075,20077,20080,27856,20211,20272,19650,19654,19672,19693,19717,19737,19757,19775,19793,19795,19800,19803,19805,19813,19815,19816,19820,19822,19848,19871,19880,19890,19900,19909,19916,19924,19932,19940,19948,19956,19964,19972,19980,19988,19996,20004,20012,20019,27857,20207,19655,19676,19696,19718,19738,19758,19776,19796,19832,20212,20213,20214,20216,20224,20229,20230,20231,19656,19677}'::integer[]))
  • Rows Removed by Filter: 3965359
Planning time : 0.190 ms
Execution time : 330,036.998 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint headers_source_id_fkey on input_data 85,229.805 ms 100 852.298 ms
for constraint official_account_source_id_fkey on headers 106,110.106 ms 185 573.568 ms
for constraint language_source_id_fkey on headers 135,896.165 ms 185 734.574 ms