explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pSWs

Settings
# exclusive inclusive rows x rows loops node
1. 0.037 0.037 ↑ 1.2 4 1

Index Scan using scheduling_recipient_contact_id_a0c95083 on scheduling_recipient (cost=0.43..20.79 rows=5 width=4) (actual time=0.023..0.037 rows=4 loops=1)

  • Index Cond: (contact_id = ANY ('{831528,624890}'::integer[]))
  • Filter: (root_flow_node_id = ANY ('{1,3,5,516439,24985103,205,30,25132064,25132066,25132068,25132070,25132072,41,25132074,25132076,25132078,1664068,516682,20722253,20722255,20722257,90,781408,101,24993383,1446505,24993387,24993389,517230,24993391,24993393,24993395,5697143,1446009,1446011,782974,955519,24976013,25000594,197,5629606,168,780969,199,201,518005,203,158405,158407,158409,158411,20112418,207,209,211,213,517846,215,20112420,782554,219,221,223,225,227,20112422,231,233,24973546,24973548,24973550,24973552,24973554,24973556,24973558,24973560,24973562,24973564,782078,24973568,24973570,24973572,24973574,24973576,24973578,24973580,24973582,24973584,1663249,217,516896,1446180,25368872,25368874,25368876,25368878,781636,24993385,158537,781143,24973656,24973658,24973660,229,24996711,24976749,24976751,24976753,24976755,24976757,24976759,956294,332187,332189,955315,1445813,955336,518223,20611037,19256798,20611039,19256800,20611041,19256802,1663463,1663465,5666798,5666800,782322,24973566,955895,517626}'::integer[]))
  • Rows Removed by Filter: 1