#	exclusive	inclusive	rows x	rows	loops	node
1.	0.000	3,856.514	↑ 1.0	1	1	→ Finalize Aggregate (cost=2,052,831.26..2,052,831.27 rows=1 width=32) (actual time=3,856.514..3,856.514 rows=1 loops=1)
2.	33.949	3,887.119	↓ 1.5	3	1	→ Gather (cost=2,052,831.04..2,052,831.25 rows=2 width=32) (actual time=3,856.428..3,887.119 rows=3 loops=1) Workers Planned: 2 Workers Launched: 2
3.	0.004	3,853.170	↑ 1.0	1	3	→ Partial Aggregate (cost=2,051,831.04..2,051,831.05 rows=1 width=32) (actual time=3,853.170..3,853.170 rows=1 loops=3)
4.	0.002	3,853.166	↓ 0.0	0	3	→ Hash Join (cost=1.21..2,049,157.91 rows=213,850 width=7) (actual time=3,853.165..3,853.166 rows=0 loops=3) Hash Cond: (m.mmt_movement_type_id = mt.id)
5.	3,853.164	3,853.164	↓ 0.0	0	3	→ Parallel Seq Scan on mmt_movement m (cost=0.00..2,046,737.53 rows=695,011 width=10) (actual time=3,853.164..3,853.164 rows=0 loops=3) Filter: ((date_settlement IS NULL) AND (date_to_settlement IS NOT NULL) AND ((phone)::text = 'f5b3c354-c48a-4de0-8613-b0bb68d73cd0'::text)) Rows Removed by Filter: 10107170
6.	0.000	0.000	↓ 0.0		0	→ Hash (cost=1.16..1.16 rows=4 width=5) (never executed)
7.	0.000	0.000	↓ 0.0		0	→ Seq Scan on mmt_movement_type mt (cost=0.00..1.16 rows=4 width=5) (never executed) Filter: (financial = 1)

 Finalize Aggregate  (cost=2052831.26..2052831.27 rows=1 width=32) (actual time=3856.514..3856.514 rows=1 loops=1)
   ->  Gather  (cost=2052831.04..2052831.25 rows=2 width=32) (actual time=3856.428..3887.119 rows=3 loops=1)
         Workers Planned: 2
         Workers Launched: 2
         ->  Partial Aggregate  (cost=2051831.04..2051831.05 rows=1 width=32) (actual time=3853.170..3853.170 rows=1 loops=3)
               ->  Hash Join  (cost=1.21..2049157.91 rows=213850 width=7) (actual time=3853.165..3853.166 rows=0 loops=3)
                     Hash Cond: (m.mmt_movement_type_id = mt.id)
                     ->  Parallel Seq Scan on mmt_movement m  (cost=0.00..2046737.53 rows=695011 width=10) (actual time=3853.164..3853.164 rows=0 loops=3)
                           Filter: ((date_settlement IS NULL) AND (date_to_settlement IS NOT NULL) AND ((phone)::text = 'f5b3c354-c48a-4de0-8613-b0bb68d73cd0'::text))
                           Rows Removed by Filter: 10107170
                     ->  Hash  (cost=1.16..1.16 rows=4 width=5) (never executed)
                           ->  Seq Scan on mmt_movement_type mt  (cost=0.00..1.16 rows=4 width=5) (never executed)
                                 Filter: (financial = 1)
 Planning time: 0.383 ms
 Execution time: 3887.165 ms

Per node type stats

node type	count	sum of times	% of query
Finalize Aggregate	1	0.000 ms	0.0 %
Gather	1	33.949 ms	0.9 %
Hash	1	0.000 ms	0.0 %
Hash Join	1	0.002 ms	0.0 %
Parallel Seq Scan	1	3,853.164 ms	99.9 %
Partial Aggregate	1	0.004 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
mmt_movement	1	3,853.164 ms	99.9 %
Parallel Seq Scan	1	3,853.164 ms	100.0 %
mmt_movement_type	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mfu3

Color mode:

Visible columns:

Per node type stats

Per table stats