explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vcVG

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 3,224.870 ↑ 1.0 1 1

Limit (cost=378,107.64..378,107.75 rows=1 width=4) (actual time=3,224.870..3,224.870 rows=1 loops=1)

2. 6.212 3,225.533 ↑ 20,009,670.0 1 1

Gather Merge (cost=378,107.64..2,712,732.13 rows=20,009,670 width=4) (actual time=3,224.868..3,225.533 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 666.171 3,219.321 ↑ 10,004,835.0 1 3 / 3

Sort (cost=377,107.61..402,119.70 rows=10,004,835 width=4) (actual time=3,219.321..3,219.321 rows=1 loops=3)

  • Sort Key: dt_reference DESC
  • Sort Method: top-N heapsort Memory: 25kB
  • Worker 0: Sort Method: top-N heapsort Memory: 25kB
  • Worker 1: Sort Method: top-N heapsort Memory: 25kB
4. 2,553.150 2,553.150 ↑ 1.2 8,003,868 3 / 3

Parallel Seq Scan on tb_investor_snapshot_dailly_summary (cost=0.00..327,083.44 rows=10,004,835 width=4) (actual time=0.190..2,553.150 rows=8,003,868 loops=3)

  • Filter: (id_contract = 8)
Planning time : 0.404 ms
Execution time : 3,225.571 ms