explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YfiB

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 1,553.774 ↓ 4.0 4 1

Nested Loop (cost=1.14..32.27 rows=1 width=4) (actual time=50.495..1,553.774 rows=4 loops=1)

2. 0.362 1,553.728 ↓ 4.0 4 1

Nested Loop (cost=0.99..24.00 rows=1 width=8) (actual time=50.479..1,553.728 rows=4 loops=1)

3. 0.254 0.254 ↓ 264.0 264 1

Index Scan using scheduling_flownode_target_content_type_id_f07c5b06 on scheduling_flownode (cost=0.56..8.58 rows=1 width=8) (actual time=0.018..0.254 rows=264 loops=1)

  • Index Cond: (target_content_type_id = 83)
4. 1,553.112 1,553.112 ↓ 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=5.785..5.883 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
5. 0.032 0.032 ↑ 1.0 1 4

Index Scan using messaging_blast_pkey on messaging_blast u0 (cost=0.14..8.17 rows=1 width=4) (actual time=0.008..0.008 rows=1 loops=4)

  • Index Cond: (id = scheduling_flownode.target_object_id)
  • Filter: ((state <> 2) AND (medium = 1))