explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mfu3

Settings
# 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)