explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FaBk

Settings
# exclusive inclusive rows x rows loops node
1. 19.894 217.109 ↓ 5,967.0 5,967 1

Sort (cost=29,535.73..29,535.73 rows=1 width=1,203) (actual time=214.711..217.109 rows=5,967 loops=1)

  • Sort Key: om_objects.created_at DESC
  • Sort Method: external merge Disk: 6,624kB
2. 1.110 197.215 ↓ 5,967.0 5,967 1

Nested Loop (cost=22,455.14..29,535.72 rows=1 width=1,203) (actual time=11.004..197.215 rows=5,967 loops=1)

3. 8.546 178.204 ↓ 5,967.0 5,967 1

Nested Loop (cost=22,454.71..29,532.67 rows=1 width=1,203) (actual time=10.998..178.204 rows=5,967 loops=1)

4. 7.138 145.790 ↓ 11,934.0 11,934 1

Nested Loop (cost=22,454.28..29,529.61 rows=1 width=1,219) (actual time=10.989..145.790 rows=11,934 loops=1)

5. 9.951 126.718 ↓ 11,934.0 11,934 1

Nested Loop (cost=22,453.85..29,526.56 rows=1 width=1,219) (actual time=10.982..126.718 rows=11,934 loops=1)

6. 1.036 104.833 ↓ 11,934.0 11,934 1

Nested Loop (cost=22,453.57..29,525.19 rows=1 width=245) (actual time=10.977..104.833 rows=11,934 loops=1)

7. 3.114 85.896 ↓ 5,967.0 5,967 1

Nested Loop (cost=22,453.15..29,521.71 rows=1 width=197) (actual time=10.971..85.896 rows=5,967 loops=1)

  • Join Filter: (rwk_transaction_objects.rwk_transaction_uuid = om_objects.object_uuid)
8. 2.637 64.881 ↓ 121.8 5,967 1

Hash Join (cost=22,452.72..29,372.22 rows=49 width=48) (actual time=10.959..64.881 rows=5,967 loops=1)

  • Hash Cond: (om_relationship_objects.object_two_uuid = rwk_transaction_objects.rwk_transaction_uuid)
9. 32.933 60.840 ↓ 11.7 5,967 1

Hash Join (cost=22,284.02..29,201.12 rows=509 width=32) (actual time=9.542..60.840 rows=5,967 loops=1)

  • Hash Cond: (om_relationship_objects.relationship_uuid = om_objects_1.object_uuid)
10. 18.662 18.662 ↓ 1.0 242,782 1

Seq Scan on om_relationship_objects (cost=0.00..6,002.19 rows=242,619 width=48) (actual time=0.005..18.662 rows=242,782 loops=1)

11. 0.950 9.245 ↑ 1.1 5,967 1

Hash (cost=22,200.56..22,200.56 rows=6,677 width=16) (actual time=9.245..9.245 rows=5,967 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 344kB
12. 6.408 8.295 ↑ 1.1 5,967 1

Bitmap Heap Scan on om_objects om_objects_1 (cost=229.82..22,200.56 rows=6,677 width=16) (actual time=2.659..8.295 rows=5,967 loops=1)

  • Recheck Cond: ((object_type)::text = 'iap_product_transaction_rel'::text)
  • Filter: (((deleted_at IS NULL) OR (deleted_at > now())) AND ((deleted_at IS NULL) OR (deleted_at > now())))
  • Heap Blocks: exact=5,990
13. 1.887 1.887 ↓ 2.4 16,433 1

Bitmap Index Scan on om_objects_type_slug_un (cost=0.00..228.15 rows=6,896 width=0) (actual time=1.887..1.887 rows=16,433 loops=1)

  • Index Cond: ((object_type)::text = 'iap_product_transaction_rel'::text)
14. 0.786 1.404 ↓ 1.0 5,970 1

Hash (cost=95.53..95.53 rows=5,853 width=16) (actual time=1.404..1.404 rows=5,970 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 344kB
15. 0.618 0.618 ↓ 1.0 5,970 1

Seq Scan on rwk_transaction_objects (cost=0.00..95.53 rows=5,853 width=16) (actual time=0.008..0.618 rows=5,970 loops=1)

16. 17.901 17.901 ↑ 1.0 1 5,967

Index Scan using om_objects_pkey on om_objects (cost=0.43..3.04 rows=1 width=149) (actual time=0.003..0.003 rows=1 loops=5,967)

  • Index Cond: (object_uuid = om_relationship_objects.object_two_uuid)
  • Filter: ((deleted_at IS NULL) OR (deleted_at > now()))
17. 17.901 17.901 ↑ 2.0 2 5,967

Index Scan using object_two_uuid_idx on om_relationship_objects om_relationship_objects_1 (cost=0.42..3.43 rows=4 width=48) (actual time=0.002..0.003 rows=2 loops=5,967)

  • Index Cond: (object_two_uuid = om_objects.object_uuid)
18. 11.934 11.934 ↑ 1.0 1 11,934

Index Scan using iap_transaction_objects_pkey on iap_transaction_objects (cost=0.28..1.37 rows=1 width=1,038) (actual time=0.001..0.001 rows=1 loops=11,934)

  • Index Cond: (iap_transaction_uuid = om_objects.object_uuid)
19. 11.934 11.934 ↑ 1.0 1 11,934

Index Scan using om_objects_pkey on om_objects iap_product_transaction_rel_two_objects (cost=0.43..3.04 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=11,934)

  • Index Cond: (object_uuid = om_relationship_objects.object_one_uuid)
  • Filter: ((deleted_at IS NULL) OR (deleted_at > now()))
20. 23.868 23.868 ↓ 0.0 0 11,934

Index Scan using om_objects_pkey on om_objects om_objects_2 (cost=0.43..3.05 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=11,934)

  • Index Cond: (object_uuid = om_relationship_objects_1.relationship_uuid)
  • Filter: (((object_type)::text = 'iap_transaction_profile_rel'::text) AND ((deleted_at IS NULL) OR (deleted_at > now())) AND ((deleted_at IS NULL) OR (deleted_at > now())))
  • Rows Removed by Filter: 0
21. 17.901 17.901 ↑ 1.0 1 5,967

Index Scan using om_objects_pkey on om_objects iap_transaction_profile_rel_two_objects (cost=0.43..3.04 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=5,967)

  • Index Cond: (object_uuid = om_relationship_objects_1.object_one_uuid)
  • Filter: ((deleted_at IS NULL) OR (deleted_at > now()))
Planning time : 7.655 ms
Execution time : 218.438 ms