explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3wtW

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 416.997 ↑ 1.0 1 1

Finalize Aggregate (cost=464,023.42..464,023.43 rows=1 width=8) (actual time=416.996..416.997 rows=1 loops=1)

2. 24.310 434.340 ↓ 1.5 3 1

Gather (cost=464,023.21..464,023.42 rows=2 width=8) (actual time=416.989..434.340 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 4.911 410.030 ↑ 1.0 1 3

Partial Aggregate (cost=463,023.21..463,023.22 rows=1 width=8) (actual time=410.030..410.030 rows=1 loops=3)

4. 11.786 405.119 ↑ 1.2 57,825 3

Hash Left Join (cost=2.17..462,842.50 rows=72,281 width=4) (actual time=0.233..405.119 rows=57,825 loops=3)

  • Hash Cond: ("Remessa".fk_estado = ("Remessa.Estado".sigla)::bpchar)
5. 386.208 393.293 ↑ 1.2 57,825 3

Nested Loop (cost=0.56..461,847.03 rows=72,281 width=7) (actual time=0.091..393.293 rows=57,825 loops=3)

6. 7.079 7.079 ↑ 1.2 57,825 3

Parallel Seq Scan on "Coleta" (cost=0.00..9,138.81 rows=72,281 width=39) (actual time=0.010..7.079 rows=57,825 loops=3)

7. 0.006 0.006 ↑ 1.0 1 173,474

Index Scan using "Remessa_pkey" on "Remessa" (cost=0.56..6.26 rows=1 width=23) (actual time=0.006..0.006 rows=1 loops=173,474)

  • Index Cond: ((codigo)::text = ("Coleta".fk_remessa)::text)
8. 0.012 0.040 ↑ 1.0 27 3

Hash (cost=1.27..1.27 rows=27 width=516) (actual time=0.040..0.040 rows=27 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
9. 0.028 0.028 ↑ 1.0 27 3

Seq Scan on "Estado" "Remessa.Estado" (cost=0.00..1.27 rows=27 width=516) (actual time=0.022..0.028 rows=27 loops=3)

Planning time : 1.113 ms