explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YsLD

Settings
# exclusive inclusive rows x rows loops node
1. 0.016 4,719.479 ↑ 1.0 1 1

Finalize Aggregate (cost=742,443.00..742,443.01 rows=1 width=8) (actual time=4,719.479..4,719.479 rows=1 loops=1)

2. 11.989 4,719.463 ↓ 1.5 3 1

Gather (cost=742,442.78..742,442.99 rows=2 width=8) (actual time=4,713.863..4,719.463 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 67.145 4,707.474 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=741,442.78..741,442.79 rows=1 width=8) (actual time=4,707.474..4,707.474 rows=1 loops=3)

4. 3,345.378 4,640.329 ↓ 1.6 945,481 3 / 3

Hash Join (cost=95,772.80..739,945.61 rows=598,871 width=8) (actual time=1,305.652..4,640.329 rows=945,481 loops=3)

  • Hash Cond: (ms.id = mb.simo_msg_send_state_id)
  • -> Parallel Seq Scan on simo_msg_send_state ms (cost=0.00..585413.50 rows=2430015 width=16) (actual time=0.077..2171.27
  • Filter: ((notify_time > '2019-08-11 16:22:00'::timestamp without time zone) AND ((account)::text = '1'::text))
  • Rows Removed by Filter: 1917133
5. 1,294.951 1,294.951 ↑ 1.0 2,836,442 3 / 3

Hash (cost=46,464.69..46,464.69 rows=2,836,569 width=16) (actual time=1,294.951..1,294.951 rows=2,836,442 loops=3)

  • Buckets: 131072 Batches: 64 Memory Usage: 3106kB
  • -> Seq Scan on simo_msg_mailbox mb (cost=0.00..46464.69 rows=2836569 width=16) (actual time=0.019..730.106 rows=2
  • Filter: (NOT is_read)
  • Rows Removed by Filter: 1