explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yLCs

Settings
# exclusive inclusive rows x rows loops node
1. 0.032 4,226.710 ↓ 14.0 14 1

Nested Loop (cost=6,936.57..6,944.65 rows=1 width=88) (actual time=3,774.278..4,226.710 rows=14 loops=1)

2. 254.182 4,226.524 ↓ 14.0 14 1

GroupAggregate (cost=6,936.15..6,936.18 rows=1 width=80) (actual time=3,774.239..4,226.524 rows=14 loops=1)

  • Group Key: ps.segment_uuid
3. 742.180 3,972.342 ↓ 1,414,807.0 1,414,807 1

Sort (cost=6,936.15..6,936.15 rows=1 width=56) (actual time=3,763.737..3,972.342 rows=1,414,807 loops=1)

  • Sort Key: ps.segment_uuid
  • Sort Method: external merge Disk: 59800kB
4. 1,002.227 3,230.162 ↓ 1,414,807.0 1,414,807 1

Hash Join (cost=3,683.50..6,936.14 rows=1 width=56) (actual time=1,611.926..3,230.162 rows=1,414,807 loops=1)

  • Hash Cond: (ps.person_uuid = t_email_f_current.person_uuid)
5. 621.880 621.880 ↓ 59.7 1,736,699 1

Index Only Scan using "person_segment$idx1" on person_segment ps (cost=0.70..2,853.40 rows=29,085 width=48) (actual time=0.086..621.880 rows=1,736,699 loops=1)

  • Index Cond: ((organization_uuid = 'ceb7f4e9-60e6-427b-b8dc-1762f9e0ba22'::uuid) AND (segment_uuid = ANY ('{0ea26491-a974-4519-89e8-e30a6abe760f,17f1619f-5443-4cca-8d02-cf4049c5c14c,2817fcbc-6304-4456-945f-128df5eebdcb,558e4fa1-fba0-43bd-a28d-7992645919d5,78d8675a-7c01-46e2-a5f5-9603560f6c0d,7e7bd296-3be2-439c-8385-5262c7518dc9,8802eaa9-5a44-4ac8-a0dc-36123477af80,8cb94d93-6319-4ed8-ac19-dc98931a1e51,93b7e2ac-20b0-4cf5-9300-1298d6ee2dac,a74b9bfe-a552-497c-bd57-8b822b02f019,ab1881c2-4e23-453b-948d-889359dee028,c0a0f41a-f4a0-47e1-9966-4db10287a8ae,d04a0c07-b407-409f-b72e-8f75b1534636,e5042584-419a-4a38-8a0f-8c735876df4a}'::uuid[])))
  • Heap Fetches: 12162
6. 637.398 1,606.055 ↓ 4,443.1 408,763 1

Hash (cost=3,681.65..3,681.65 rows=92 width=72) (actual time=1,606.055..1,606.055 rows=408,763 loops=1)

  • Buckets: 65536 (originally 1024) Batches: 16 (originally 1) Memory Usage: 3585kB
7. 105.738 968.657 ↓ 4,443.1 408,763 1

Nested Loop (cost=1.11..3,681.65 rows=92 width=72) (actual time=0.099..968.657 rows=408,763 loops=1)

8. 0.030 0.030 ↑ 1.0 1 1

Index Only Scan using "t_email_blast_dim$idx3" on t_email_blast_dim (cost=0.42..4.44 rows=1 width=32) (actual time=0.027..0.030 rows=1 loops=1)

  • Index Cond: ((b_identity_uuid = '7f31684a-6d72-4575-b71e-f54000720c18'::uuid) AND (bc_organization_uuid = 'ceb7f4e9-60e6-427b-b8dc-1762f9e0ba22'::uuid))
  • Heap Fetches: 0
9. 59.557 862.889 ↓ 450.2 408,763 1

Append (cost=0.70..3,668.14 rows=908 width=88) (actual time=0.068..862.889 rows=408,763 loops=1)

10. 803.292 803.292 ↓ 1,265.5 408,763 1

Index Scan using "t_email_f_current$idx2" on t_email_f_current (cost=0.70..1,313.44 rows=323 width=88) (actual time=0.066..803.292 rows=408,763 loops=1)

  • Index Cond: ((organization_uuid = 'ceb7f4e9-60e6-427b-b8dc-1762f9e0ba22'::uuid) AND (blast_content_id = t_email_blast_dim.bc_identity_uuid))
11. 0.040 0.040 ↓ 0.0 0 1

Index Scan using "t_email_f_archive$idx2" on t_email_f_archive (cost=0.70..2,354.70 rows=585 width=88) (actual time=0.040..0.040 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'ceb7f4e9-60e6-427b-b8dc-1762f9e0ba22'::uuid) AND (blast_content_id = t_email_blast_dim.bc_identity_uuid))
12. 0.154 0.154 ↑ 1.0 1 14

Index Scan using organization_segment_identity_lookup on t_organization_segment tos (cost=0.42..8.45 rows=1 width=40) (actual time=0.011..0.011 rows=1 loops=14)

  • Index Cond: ((identity_uuid = ps.segment_uuid) AND (effective_end = '2100-01-01 00:00:00-05'::timestamp with time zone))