explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7cog

Settings
# exclusive inclusive rows x rows loops node
1. 4.811 988.400 ↓ 0.0 0 1

Gather (cost=1,000.00..283,195.58 rows=100 width=4) (actual time=988.400..988.400 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 983.589 983.589 ↓ 0.0 0 3 / 3

Parallel Seq Scan on input_data (cost=0.00..282,185.58 rows=42 width=4) (actual time=983.589..983.589 rows=0 loops=3)

  • 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: 1321820
Planning time : 0.272 ms
Execution time : 989.910 ms