explain.depesz.com

PostgreSQL's explain analyze made readable

Result: D8Ni

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 25,117.026 ↓ 0.0 0 1

Unique (cost=8,629,195.56..8,629,205.28 rows=1,908 width=4) (actual time=25,117.026..25,117.026 rows=0 loops=1)

2. 0.000 25,117.025 ↓ 0.0 0 1

Sort (cost=8,629,195.56..8,629,200.42 rows=1,943 width=4) (actual time=25,117.025..25,117.025 rows=0 loops=1)

  • Sort Key: packet_list_id_
  • Sort Method: quicksort Memory: 25kB
3. 1,798.384 26,905.670 ↓ 0.0 0 1

Gather (cost=1,000.00..8,629,089.44 rows=1,943 width=4) (actual time=25,117.000..26,905.670 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 25,107.286 25,107.286 ↓ 0.0 0 3

Parallel Seq Scan on ac_packet_list_mail (cost=0.00..8,627,895.14 rows=810 width=4) (actual time=25,107.286..25,107.286 rows=0 loops=3)

  • Filter: (mail_id_ = 688379063)
  • Rows Removed by Filter: 220864959
Planning time : 0.281 ms
Execution time : 26,905.848 ms