#	rows x	node
1.	↓ 0.0	→ Limit (cost=0.00..1388891.58 rows=1000 width=138) (actual time=.. rows= loops=)
2.	↓ 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.0	→ Nested Loop (cost=0.00..31463084823.90 rows=343138936 width=122) (actual time=.. rows= loops=)
4.	↓ 0.0	→ Nested Loop (cost=0.00..17722559954.00 rows=346640000 width=42) (actual time=.. rows= loops=)
5.	↓ 0.0	→ Seq Scan on "Payments" p (cost=0.00..5724570.00 rows=350000000 width=18) (actual time=.. rows= loops=)
6.	↓ 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.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.0	→ Materialize (cost=0.00..1.19 rows=1 width=16) (actual time=.. rows= loops=)
9.	↓ 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)

Limit  (cost=0.00..1388891.58 rows=1000 width=138)
  ->  Nested Loop  (cost=0.00..31468231909.13 rows=22657083 width=138)
        Join Filter: (u."RoleId" = r."Id")
        ->  Nested Loop  (cost=0.00..31463084823.90 rows=343138936 width=122)
              ->  Nested Loop  (cost=0.00..17722559954.00 rows=346640000 width=42)
                    ->  Seq Scan on "Payments" p  (cost=0.00..5724570.00 rows=350000000 width=18)
                    ->  Index Scan using "PaymentOrders_pkey" on "PaymentOrders" po  (cost=0.00..50.61 rows=1 width=24)
                          Index Cond: ("Id" = p."PaymentOrderId")
              ->  Index Scan using "Users_pkey" on "Users" u  (cost=0.00..39.63 rows=1 width=80)
                    Index Cond: ("Id" = po."UserId")
        ->  Materialize  (cost=0.00..1.19 rows=1 width=16)
              ->  Seq Scan on "Roles" r  (cost=0.00..1.19 rows=1 width=16)
                    Filter: (("Name")::text = 'Moses2333'::text)

Per node type stats

node type	count	sum of times	% of query
Index Scan	2	0.000 ms	0.0 %
Limit	1	0.000 ms	0.0 %
Materialize	1	0.000 ms	0.0 %
Nested Loop	3	0.000 ms	0.0 %
Seq Scan	2	0.000 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
"PaymentOrders"	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
"Payments"	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
"Roles"	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
"Users"	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: hol : Postgresql slow query explain

Colorize:

Columns visibility:

Per node type stats

Per table stats