explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DZVO

Settings
# exclusive inclusive rows x rows loops node
1. 0.644 764.727 ↓ 772.0 772 1

Nested Loop Left Join (cost=50.37..1,895.17 rows=1 width=397) (actual time=1.773..764.727 rows=772 loops=1)

2. 0.922 761.767 ↓ 772.0 772 1

Nested Loop Left Join (cost=50.09..1,894.82 rows=1 width=393) (actual time=1.766..761.767 rows=772 loops=1)

  • Filter: ((conf_conference_badge_rel_two_objects.deleted_at IS NULL) OR (conf_conference_badge_rel_two_objects.deleted_at > now()))
3. 1.288 758.529 ↓ 772.0 772 1

Nested Loop Left Join (cost=49.67..1,893.74 rows=1 width=393) (actual time=1.760..758.529 rows=772 loops=1)

  • Filter: ((conf_badge_photo_rel_one_objects.deleted_at IS NULL) OR (conf_badge_photo_rel_one_objects.deleted_at > now()))
4. 1.450 754.925 ↓ 772.0 772 1

Nested Loop Left Join (cost=49.26..1,892.65 rows=1 width=393) (actual time=1.759..754.925 rows=772 loops=1)

5. 1.272 419.971 ↓ 772.0 772 1

Nested Loop Left Join (cost=48.43..1,795.73 rows=1 width=377) (actual time=1.047..419.971 rows=772 loops=1)

6. 0.887 34.243 ↓ 772.0 772 1

Nested Loop (cost=47.60..1,699.90 rows=1 width=361) (actual time=0.875..34.243 rows=772 loops=1)

7. 0.875 30.268 ↓ 772.0 772 1

Nested Loop (cost=47.19..1,698.82 rows=1 width=361) (actual time=0.867..30.268 rows=772 loops=1)

8. 1.059 27.077 ↓ 772.0 772 1

Nested Loop (cost=46.91..1,698.51 rows=1 width=347) (actual time=0.863..27.077 rows=772 loops=1)

9. 1.335 23.702 ↓ 772.0 772 1

Nested Loop (cost=46.64..1,698.20 rows=1 width=331) (actual time=0.856..23.702 rows=772 loops=1)

  • Join Filter: (conf_badge_objects.conf_badge_uuid = om_objects.object_uuid)
10. 2.090 16.191 ↓ 51.5 772 1

Nested Loop (cost=46.22..1,678.14 rows=15 width=188) (actual time=0.820..16.191 rows=772 loops=1)

11. 5.407 9.433 ↓ 1.4 1,556 1

Hash Join (cost=45.81..431.95 rows=1,141 width=204) (actual time=0.783..9.433 rows=1,556 loops=1)

  • Hash Cond: (om_relationship_objects.object_two_uuid = conf_badge_objects.conf_badge_uuid)
12. 3.340 3.340 ↑ 1.0 12,384 1

Seq Scan on om_relationship_objects (cost=0.00..328.17 rows=12,417 width=48) (actual time=0.007..3.340 rows=12,384 loops=1)

13. 0.376 0.686 ↓ 1.0 778 1

Hash (cost=36.47..36.47 rows=747 width=156) (actual time=0.685..0.686 rows=778 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 154kB
14. 0.310 0.310 ↓ 1.0 778 1

Seq Scan on conf_badge_objects (cost=0.00..36.47 rows=747 width=156) (actual time=0.005..0.310 rows=778 loops=1)

15. 4.668 4.668 ↓ 0.0 0 1,556

Index Scan using om_objects_pkey on om_objects om_objects_1 (cost=0.41..1.08 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,556)

  • Index Cond: (object_uuid = om_relationship_objects.relationship_uuid)
  • Filter: (((object_type)::text = 'conf_profile_badge_rel'::text) AND ((deleted_at IS NULL) OR (deleted_at > now())) AND ((deleted_at IS NULL) OR (deleted_at > now())))
  • Rows Removed by Filter: 1
16. 6.176 6.176 ↑ 1.0 1 772

Index Scan using om_objects_pkey on om_objects (cost=0.41..1.32 rows=1 width=143) (actual time=0.008..0.008 rows=1 loops=772)

  • Index Cond: (object_uuid = om_relationship_objects.object_two_uuid)
  • Filter: ((deleted_at IS NULL) AND ((deleted_at IS NULL) OR (deleted_at > now())) AND om_permissions__readable(NULL::uuid, NULL::uuid[], owner_uuid, group_uuid, permissions))
17. 2.316 2.316 ↑ 1.0 1 772

Index Only Scan using om_domain_objects_pkey on om_domain_objects (cost=0.28..0.30 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=772)

  • Index Cond: (domain_object_uuid = om_objects.object_uuid)
  • Heap Fetches: 772
18. 2.316 2.316 ↑ 1.0 1 772

Index Scan using ada_conf_badge_objects_pkey on ada_conf_badge_objects (cost=0.28..0.30 rows=1 width=78) (actual time=0.002..0.003 rows=1 loops=772)

  • Index Cond: (ada_conf_badge_uuid = om_objects.object_uuid)
19. 3.088 3.088 ↑ 1.0 1 772

Index Scan using om_objects_pkey on om_objects conf_profile_badge_rel_two_objects (cost=0.41..1.07 rows=1 width=16) (actual time=0.003..0.004 rows=1 loops=772)

  • Index Cond: (object_uuid = om_relationship_objects.object_one_uuid)
  • Filter: ((deleted_at IS NULL) OR (deleted_at > now()))
20. 3.052 384.456 ↑ 1.0 1 772

Nested Loop (cost=0.82..95.81 rows=1 width=32) (actual time=0.111..0.498 rows=1 loops=772)

21. 376.736 376.736 ↑ 1.0 2 772

Index Scan using om_object_rels_un on om_relationship_objects om_relationship_objects_2 (cost=0.41..93.63 rows=2 width=48) (actual time=0.106..0.488 rows=2 loops=772)

  • Index Cond: (object_two_uuid = om_objects.object_uuid)
22. 4.668 4.668 ↓ 0.0 0 1,556

Index Scan using om_objects_pkey on om_objects om_objects_3 (cost=0.41..1.08 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1,556)

  • Index Cond: (object_uuid = om_relationship_objects_2.relationship_uuid)
  • Filter: (((object_type)::text = 'conf_conference_badge_rel'::text) AND ((deleted_at IS NULL) OR (deleted_at > now())) AND ((deleted_at IS NULL) OR (deleted_at > now())))
  • Rows Removed by Filter: 1
23. 1.616 333.504 ↑ 1.0 1 772

Nested Loop (cost=0.82..96.92 rows=1 width=32) (actual time=0.077..0.432 rows=1 loops=772)

24. 328.872 328.872 ↑ 3.0 1 772

Index Scan using om_object_rels_un on om_relationship_objects om_relationship_objects_1 (cost=0.41..93.64 rows=3 width=48) (actual time=0.072..0.426 rows=1 loops=772)

  • Index Cond: (object_one_uuid = om_objects.object_uuid)
25. 3.016 3.016 ↑ 1.0 1 754

Index Scan using om_objects_pkey on om_objects om_objects_2 (cost=0.41..1.08 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=754)

  • Index Cond: (object_uuid = om_relationship_objects_1.relationship_uuid)
  • Filter: (((object_type)::text = 'conf_badge_photo_rel'::text) AND ((deleted_at IS NULL) OR (deleted_at > now())) AND ((deleted_at IS NULL) OR (deleted_at > now())))
26. 2.316 2.316 ↑ 1.0 1 772

Index Scan using om_objects_pkey on om_objects conf_badge_photo_rel_one_objects (cost=0.41..1.07 rows=1 width=24) (actual time=0.003..0.003 rows=1 loops=772)

  • Index Cond: (om_relationship_objects_1.object_two_uuid = object_uuid)
27. 2.316 2.316 ↑ 1.0 1 772

Index Scan using om_objects_pkey on om_objects conf_conference_badge_rel_two_objects (cost=0.41..1.07 rows=1 width=24) (actual time=0.003..0.003 rows=1 loops=772)

  • Index Cond: (om_relationship_objects_2.object_one_uuid = object_uuid)
28. 2.316 2.316 ↓ 0.0 0 772

Index Scan using om_rels_agg_un on om_relationship_aggregate_objects ada_conf_session_conf_badge_rel_one (cost=0.28..0.34 rows=1 width=20) (actual time=0.003..0.003 rows=0 loops=772)