explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UdYC

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0 0 1

Limit (cost=126.39..126.40 rows=1 width=817) (actual time=0.000..0.000 rows=0 loops=1)

2. 0.000 0.000 ↓ 0.0 0

Sort (cost=126.39..126.40 rows=1 width=817) (never executed)

  • Sort Key: om_objects.object_uuid
3. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=19.20..126.38 rows=1 width=817) (never executed)

4. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=18.79..118.07 rows=1 width=817) (never executed)

  • Filter: ((tpg_booking_transporter_payment_rel_two_objects.deleted_at IS NULL) OR (tpg_booking_transporter_payment_rel_two_objects.deleted_at > now()))
5. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=18.37..109.76 rows=1 width=817) (never executed)

6. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=17.96..108.95 rows=1 width=801) (never executed)

  • Join Filter: (om_domain_objects.domain_object_uuid = tpg_booking_payment_objects.tpg_booking_payment_uuid)
7. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=17.80..108.77 rows=1 width=849) (never executed)

8. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=17.39..102.91 rows=1 width=707) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=17.11..102.13 rows=1 width=691) (never executed)

  • Hash Cond: (wlt_wallet_transaction_rel_two.object_two_uuid = wlt_transaction_objects.wlt_transaction_uuid)
10. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on om_relationship_objects wlt_wallet_transaction_rel_two (cost=4.64..89.54 rows=29 width=32) (never executed)

  • Recheck Cond: ((rel_type)::text = 'wlt_wallet_transaction_rel'::text)
11. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on om_object_rels_un (cost=0.00..4.63 rows=29 width=0) (never executed)

  • Index Cond: ((rel_type)::text = 'wlt_wallet_transaction_rel'::text)
12. 0.000 0.000 ↓ 0.0 0

Hash (cost=11.10..11.10 rows=110 width=659) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Seq Scan on wlt_transaction_objects (cost=0.00..11.10 rows=110 width=659) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Index Only Scan using om_domain_objects_pkey on om_domain_objects (cost=0.28..0.77 rows=1 width=16) (never executed)

  • Index Cond: (domain_object_uuid = wlt_transaction_objects.wlt_transaction_uuid)
  • Heap Fetches: 0
15. 0.000 0.000 ↓ 0.0 0

Index Scan using om_objects_pkey on om_objects (cost=0.42..5.85 rows=1 width=142) (never executed)

  • Index Cond: (object_uuid = om_domain_objects.domain_object_uuid)
  • Filter: ((deleted_at IS NULL) AND ((deleted_at IS NULL) OR (deleted_at > now())) AND om_permissions__readable('0def65c5-2df8-4a66-bce4-fdb8dae03b0c'::uuid, '{0dd4f518-8027-11e9-a17e-02842baf4666,ae43aa3c-4eac-11e9-b9e9-02842baf4666}'::uuid[], owner_uuid, group_uuid, permissions))
16. 0.000 0.000 ↓ 0.0 0

Index Only Scan using tpg_booking_payment_objects_pkey on tpg_booking_payment_objects (cost=0.15..0.17 rows=1 width=16) (never executed)

  • Index Cond: (tpg_booking_payment_uuid = om_objects.object_uuid)
  • Heap Fetches: 0
17. 0.000 0.000 ↓ 0.0 0

Index Only Scan using om_object_rels_un on om_relationship_objects tpg_booking_transporter_payment_rel_two (cost=0.41..0.80 rows=1 width=32) (never executed)

  • Index Cond: ((rel_type = 'tpg_booking_transporter_payment_rel'::text) AND (object_two_uuid = om_objects.object_uuid))
  • Heap Fetches: 0
18. 0.000 0.000 ↓ 0.0 0

Index Scan using om_objects_pkey on om_objects tpg_booking_transporter_payment_rel_two_objects (cost=0.42..8.30 rows=1 width=24) (never executed)

  • Index Cond: (tpg_booking_transporter_payment_rel_two.object_one_uuid = object_uuid)
19. 0.000 0.000 ↓ 0.0 0

Index Scan using om_objects_pkey on om_objects wlt_wallet_transaction_rel_two_objects (cost=0.42..8.30 rows=1 width=16) (never executed)

  • Index Cond: (object_uuid = wlt_wallet_transaction_rel_two.object_one_uuid)
  • Filter: ((deleted_at IS NULL) OR (deleted_at > now()))
Planning time : 10.449 ms