explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9EHu

Settings
# exclusive inclusive rows x rows loops node
1. 0.094 162.578 ↑ 1.0 1 1

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

2. 2.068 162.484 ↓ 13.6 488 1

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

3. 6.679 126.603 ↓ 94.7 11,271 1

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

4. 12.195 76.517 ↓ 1.7 14,469 1

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

5. 19.343 20.915 ↓ 10.8 14,469 1

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

  • Recheck Cond: (content_id = '6530aed0-191b-49e6-a790-c7f08c0bfcb6'::uuid)
  • Filter: ((domain = 131) AND (content_name = 'brochure'::text))
6. 1.572 1.572 ↓ 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=1.572..1.572 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