explain.depesz.com

A tool for finding a real cause for slow queries.

Result: hol : Postgresql slow query explain

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=0.00..1388891.58 rows=1000 width=138) (actual time=.. rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..31468231909.13 rows=22657083 width=138) (actual time=.. rows= loops=)

  • Join Filter: (u."RoleId" = r."Id")
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..31463084823.90 rows=343138936 width=122) (actual time=.. rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..17722559954.00 rows=346640000 width=42) (actual time=.. rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on "Payments" p (cost=0.00..5724570.00 rows=350000000 width=18) (actual time=.. rows= loops=)

6. 0.000 0.000 ↓ 0.0

Index Scan using "PaymentOrders_pkey" on "PaymentOrders" po (cost=0.00..50.61 rows=1 width=24) (actual time=.. rows= loops=)

  • Index Cond: ("Id" = p."PaymentOrderId")
7. 0.000 0.000 ↓ 0.0

Index Scan using "Users_pkey" on "Users" u (cost=0.00..39.63 rows=1 width=80) (actual time=.. rows= loops=)

  • Index Cond: ("Id" = po."UserId")
8. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..1.19 rows=1 width=16) (actual time=.. rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on "Roles" r (cost=0.00..1.19 rows=1 width=16) (actual time=.. rows= loops=)

  • Filter: (("Name")::text = 'Moses2333'::text)