explain.depesz.com

PostgreSQL's explain analyze made readable

Result: D4dK

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 4,564.967 ↑ 1.0 1 1

Finalize Aggregate (cost=742,361.86..742,361.87 rows=1 width=8) (actual time=4,564.967..4,564.967 rows=1 loops=1)

2. 43.623 4,564.954 ↓ 1.5 3 1

Gather (cost=742,361.65..742,361.86 rows=2 width=8) (actual time=4,508.368..4,564.954 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 68.157 4,521.331 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=741,361.65..741,361.66 rows=1 width=8) (actual time=4,521.331..4,521.331 rows=1 loops=3)

4. 3,347.957 4,453.174 ↓ 1.6 945,418 3 / 3

Hash Join (cost=95,767.27..739,864.55 rows=598,838 width=8) (actual time=1,120.623..4,453.174 rows=945,418 loops=3)

  • Hash Cond: (ms.id = mb.simo_msg_send_state_id)
  • -> Parallel Seq Scan on simo_msg_send_state ms (cost=0.00..585345.09 rows=2429731 width=16) (actual time=0.046..2023.45
  • Filter: ((notify_time > '2019-08-11 16:22:00'::timestamp without time zone) AND ((account)::text = '1'::text))
  • Rows Removed by Filter: 1917008
5. 1,105.217 1,105.217 ↑ 1.0 2,836,254 3 / 3

Hash (cost=46,462.12..46,462.12 rows=2,836,412 width=16) (actual time=1,105.217..1,105.217 rows=2,836,254 loops=3)

  • Buckets: 131072 Batches: 64 Memory Usage: 3106kB
  • -> Seq Scan on simo_msg_mailbox mb (cost=0.00..46462.12 rows=2836412 width=16) (actual time=0.029..548.657 rows=2
  • Filter: (NOT is_read)
  • Rows Removed by Filter: 1
Planning time : 0.809 ms
Execution time : 4,569.368 ms