explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ce1U

Settings
# exclusive inclusive rows x rows loops node
1. 0.095 169.502 ↑ 1.0 1 1

Aggregate (cost=153,755.03..153,755.04 rows=1 width=0) (actual time=169.502..169.502 rows=1 loops=1)

2. 3.765 169.407 ↓ 13.6 488 1

Nested Loop (cost=172.31..153,754.94 rows=36 width=0) (actual time=7.737..169.407 rows=488 loops=1)

3. 8.281 131.829 ↓ 94.7 11,271 1

Nested Loop (cost=171.87..153,694.67 rows=119 width=16) (actual time=6.301..131.829 rows=11,271 loops=1)

4. 11.806 80.141 ↓ 1.7 14,469 1

Nested Loop (cost=171.45..149,247.77 rows=8,497 width=36) (actual time=6.253..80.141 rows=14,469 loops=1)

5. 21.361 24.928 ↓ 10.8 14,469 1

Bitmap Heap Scan on publish (cost=171.01..12,274.78 rows=1,334 width=20) (actual time=6.236..24.928 rows=14,469 loops=1)

  • Recheck Cond: (content_id = '6530aed0-191b-49e6-a790-c7f08c0bfcb6'::uuid)
  • Filter: ((domain = 131) AND (content_name = 'brochure'::text))
6. 3.567 3.567 ↓ 1.1 14,812 1

Bitmap Index Scan on publish_content_id_idx (cost=0.00..170.68 rows=13,314 width=0) (actual time=3.567..3.567 rows=14,812 loops=1)

  • Index Cond: (content_id = '6530aed0-191b-49e6-a790-c7f08c0bfcb6'::uuid)
7. 43.407 43.407 ↑ 528.0 1 14,469

Index Scan using publish_queue_publish_id_idx on publish_queue (cost=0.43..97.40 rows=528 width=48) (actual time=0.003..0.003 rows=1 loops=14,469)

  • Index Cond: (publish_id = publish.id)
8. 43.407 43.407 ↑ 1.0 1 14,469

Index Scan using canalytics_open_send_id_idx on canalytics_open (cost=0.43..0.51 rows=1 width=20) (actual time=0.003..0.003 rows=1 loops=14,469)

  • Index Cond: (send_id = publish_queue.send_id)
  • Filter: (domain = 131)
9. 33.813 33.813 ↓ 0.0 0 11,271

Index Scan using mtmsg_id on mt_message (cost=0.43..0.50 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=11,271)

  • Index Cond: (id = publish_queue.mt_message_id)
  • Filter: (type = 0)
  • Rows Removed by Filter: 1