explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UHUvg : Optimization for: plan #a4Yy

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.007 7,777.280 ↑ 1.0 1 1

Finalize Aggregate (cost=692,559.48..692,559.49 rows=1 width=8) (actual time=7,777.280..7,777.280 rows=1 loops=1)

2. 26.160 7,777.273 ↓ 1.5 3 1

Gather (cost=692,559.26..692,559.47 rows=2 width=8) (actual time=7,777.248..7,777.273 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 249.369 7,751.113 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=691,559.26..691,559.27 rows=1 width=8) (actual time=7,751.113..7,751.113 rows=1 loops=3)

4. 3,438.188 7,501.744 ↓ 1.6 945,481 3 / 3

Hash Join (cost=95,736.97..690,077.81 rows=592,580 width=8) (actual time=2,029.871..7,501.744 rows=945,481 loops=3)

  • Hash Cond: (ms.id = mb.simo_msg_send_state_id)
5. 2,038.735 2,038.735 ↑ 1.3 1,917,133 3 / 3

Parallel Seq Scan on simo_msg_send_state ms (cost=0.00..536,075.50 rows=2,403,127 width=16) (actual time=0.052..2,038.735 rows=1,917,133 loops=3)

  • Filter: ((notify_time > '2019-08-11 16:22:00'::timestamp without time zone) AND ((account)::text = '1'::text))
  • Rows Removed by Filter: 1,917,133
6. 983.646 2,024.821 ↑ 1.0 2,836,442 3 / 3

Hash (cost=46,431.43..46,431.43 rows=2,836,443 width=16) (actual time=2,024.821..2,024.821 rows=2,836,442 loops=3)

  • Buckets: 131,072 Batches: 64 Memory Usage: 3,106kB
7. 1,041.175 1,041.175 ↑ 1.0 2,836,442 3 / 3

Seq Scan on simo_msg_mailbox mb (cost=0.00..46,431.43 rows=2,836,443 width=16) (actual time=0.058..1,041.175 rows=2,836,442 loops=3)

  • Filter: (NOT is_read)
  • Rows Removed by Filter: 1