explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DS68 : fsad

Settings
# exclusive inclusive rows x rows loops node
1. 324.148 7,206.697 ↓ 4,645.3 929,067 1

Finalize GroupAggregate (cost=20,781.95..20,832.62 rows=200 width=19) (actual time=5,114.264..7,206.697 rows=929,067 loops=1)

  • Group Key: "UAT EMI Central$Posted Document Web Info"."Document No_
2. 2,864.046 6,882.549 ↓ 2,323.0 929,201 1

Gather Merge (cost=20,781.95..20,828.62 rows=400 width=19) (actual time=5,114.255..6,882.549 rows=929,201 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 3,417.900 4,018.503 ↓ 1,548.7 309,734 3 / 3

Sort (cost=19,781.93..19,782.43 rows=200 width=19) (actual time=3,441.061..4,018.503 rows=309,734 loops=3)

  • Sort Key: "UAT EMI Central$Posted Document Web Info"."Document No_
  • Sort Method: external merge Disk: 16,304kB
  • Worker 0: Sort Method: external merge Disk: 11,184kB
  • Worker 1: Sort Method: external merge Disk: 3,456kB
4. 458.826 600.603 ↓ 1,548.7 309,734 3 / 3

Partial HashAggregate (cost=19,772.28..19,774.28 rows=200 width=19) (actual time=429.118..600.603 rows=309,734 loops=3)

  • Group Key: "UAT EMI Central$Posted Document Web Info"."Document No_
5. 22.583 141.777 ↑ 1.3 313,028 3 / 3

Parallel Append (cost=0.00..17,814.65 rows=391,527 width=11) (actual time=0.016..141.777 rows=313,028 loops=3)

6. 118.178 118.178 ↑ 1.3 309,599 3 / 3

Parallel Seq Scan on "UAT EMI Central$Posted Document Web Info" (cost=0.00..15,699.16 rows=387,239 width=11) (actual time=0.011..118.178 rows=309,599 loops=3)

  • Filter: (("Table ID" = 112) AND ("Send Electronically" = 1))
  • Rows Removed by Filter: 105,025
7. 0.513 0.513 ↓ 1.7 5,777 1 / 3

Parallel Seq Scan on "UAT WAG FR$Posted Document Web Info" (cost=0.00..88.03 rows=3,398 width=14) (actual time=0.005..1.538 rows=5,777 loops=1)

  • Filter: (("Table ID" = 112) AND ("Send Electronically" = 1))
  • Rows Removed by Filter: 6
8. 0.321 0.321 ↓ 1.7 2,915 1 / 3

Parallel Seq Scan on "UAT WAG ES$Posted Document Web Info" (cost=0.00..44.73 rows=1,715 width=14) (actual time=0.006..0.963 rows=2,915 loops=1)

  • Filter: (("Table ID" = 112) AND ("Send Electronically" = 1))
  • Rows Removed by Filter: 1
9. 0.158 0.158 ↓ 1.7 1,407 1 / 3

Parallel Seq Scan on "UAT WAG BE$Posted Document Web Info" (cost=0.00..21.44 rows=828 width=14) (actual time=0.005..0.473 rows=1,407 loops=1)

  • Filter: (("Table ID" = 112) AND ("Send Electronically" = 1))
  • Rows Removed by Filter: 3
10. 0.025 0.025 ↓ 1.7 188 1 / 3

Parallel Seq Scan on "UAT WAG CZ$Posted Document Web Info" (cost=0.00..3.66 rows=111 width=14) (actual time=0.014..0.074 rows=188 loops=1)

  • Filter: (("Table ID" = 112) AND ("Send Electronically" = 1))
Planning time : 0.399 ms
Execution time : 7,300.639 ms