explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aipF

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 2,864.142 ↓ 0.0 0 1

Delete on input_data (cost=0.00..594,190.33 rows=100 width=6) (actual time=2,864.142..2,864.142 rows=0 loops=1)

2. 2,864.140 2,864.140 ↓ 0.0 0 1

Seq Scan on input_data (cost=0.00..594,190.33 rows=100 width=6) (actual time=2,864.140..2,864.140 rows=0 loops=1)

  • Filter: (batch_id = ANY ('{32128,25183,32129,32130,32131,32132,165594,82323,80841,80842,171118,27850,27851,27852,20202,20242,20246,20250,20251,20268,27853,20203,20243,20269,27854,20189,20190,20191,20192,20193,20194,20195,20196,20197,20198,20199,20200,20201,27855,20205,25206,25207,25208,20204,20206,25209,22483,25212,20208,22599,19651,19673,19680,19714,19733,19734,19754,19767,19792,19812,19831,19878,19881,19888,19891,22484,25213,22512,20209,22559,22600,22659,22660,19652,19674,19694,19715,19735,19744,19745,19755,19762,19764,19765,19785,22485,25205,25214,25215,25218,20210,22508,19653,19675,19695,19716,19736,19756,19774,19794}'::integer[]))
  • Rows Removed by Filter: 3965459
Planning time : 0.342 ms
Execution time : 2,864.166 ms