explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PRB

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

Finalize Aggregate (cost=464,396.22..464,396.23 rows=1 width=8) (actual time=428.890..428.890 rows=1 loops=1)

2. 23.201 445.949 ↓ 1.5 3 1

Gather (cost=464,396.01..464,396.22 rows=2 width=8) (actual time=428.764..445.949 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 4.954 422.748 ↑ 1.0 1 3

Partial Aggregate (cost=463,396.01..463,396.02 rows=1 width=8) (actual time=422.748..422.748 rows=1 loops=3)

4. 11.960 417.794 ↑ 1.3 57,825 3

Hash Left Join (cost=2.17..463,215.11 rows=72,357 width=4) (actual time=0.157..417.794 rows=57,825 loops=3)

  • Hash Cond: ("Remessa".fk_estado = ("Remessa.Estado".sigla)::bpchar)
5. 398.496 405.807 ↑ 1.3 57,825 3

Nested Loop (cost=0.56..462,218.60 rows=72,357 width=7) (actual time=0.065..405.807 rows=57,825 loops=3)

6. 7.305 7.305 ↑ 1.3 57,825 3

Parallel Seq Scan on "Coleta" (cost=0.00..9,139.57 rows=72,357 width=39) (actual time=0.007..7.305 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.009 0.027 ↑ 1.0 27 3

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

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

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

Planning time : 0.669 ms