explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vw5t : Optimization for: plan #kK0Q

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.100 412.002 ↓ 4.0 4 1

Nested Loop (cost=0.99..24.20 rows=1 width=4) (actual time=12.073..412.002 rows=4 loops=1)

2. 0.326 0.326 ↓ 264.0 264 1

Index Scan using scheduling_flownode_target_content_type_id_f07c5b06 on scheduling_flownode (cost=0.56..8.78 rows=1 width=4) (actual time=0.012..0.326 rows=264 loops=1)

  • Index Cond: (target_content_type_id = 83)
  • Filter: (target_object_id = ANY ('{13,1,63,158,155,156,157,153,154,147,151,150,149,152,3,2,38,4,48,14,45,27,26,15,60,35,31,30,6,49,5,7,16,8,64,9,10,21,22,40,17,11,28,12,23,32,47,18,24,66,19,44,29,67,20,43,25,52,41,37,50,46,36,84,34,33,51,65,39,54,42,59,69,53,57,55,62,58,56,70,61,72,71,73,74,75,76,77,79,78,90,113,111,86,80,82,81,104,83,148,98,97,99,120,110,85,87,88,89,91,92,103,93,100,101,105,102,106,94,95,96,109,107,108,116,117,127,114,130,123,125,119,121,128,122,139,124,129,118,126,115,112,144,145,131,136,133,132,134,137,135,143,142,138,141,140,146}'::integer[]))
3. 411.576 411.576 ↓ 0.0 0 264

Index Scan using scheduling_recipient_root_flow_node_id_c09513aa on scheduling_recipient (cost=0.43..15.41 rows=1 width=8) (actual time=1.505..1.559 rows=0 loops=264)

  • Index Cond: (root_flow_node_id = scheduling_flownode.id)
  • Filter: (contact_id = ANY ('{623049,829523,1157156}'::integer[]))
  • Rows Removed by Filter: 6846