explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TtTl

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 457.401 1,465.158 ↓ 1.0 1,480,092 1

Hash Left Join (cost=713.37..134,467.69 rows=1,479,928 width=588) (actual time=12.424..1,465.158 rows=1,480,092 loops=1)

  • Hash Cond: ((zapr.gl_accounts)::text = (ref.gl)::text)
2. 368.364 1,007.737 ↓ 1.0 1,480,092 1

Hash Left Join (cost=711.79..116,090.34 rows=1,479,928 width=585) (actual time=12.377..1,007.737 rows=1,480,092 loops=1)

  • Hash Cond: (zapr.pcard_keyhash = pcard.sap_keyhash)
3. 627.128 627.128 ↓ 1.0 1,479,986 1

Seq Scan on eba_pipeline_opex_inbound_sap_zapr_mrkt zapr (cost=0.00..93,071.28 rows=1,479,928 width=372) (actual time=0.046..627.128 rows=1,479,986 loops=1)

  • Filter: (current_flag AND (NOT delete_flag))
4. 5.842 12.245 ↑ 1.0 10,835 1

Hash (cost=576.35..576.35 rows=10,835 width=246) (actual time=12.245..12.245 rows=10,835 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 3135kB
5. 6.403 6.403 ↑ 1.0 10,835 1

Seq Scan on eba_pipeline_opex_inbound_concur_pcrd_gl pcard (cost=0.00..576.35 rows=10,835 width=246) (actual time=0.012..6.403 rows=10,835 loops=1)

6. 0.007 0.020 ↑ 1.0 26 1

Hash (cost=1.26..1.26 rows=26 width=11) (actual time=0.020..0.020 rows=26 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
7. 0.013 0.013 ↑ 1.0 26 1

Seq Scan on eba_pipeline_opex_reference_gl_team_mapping ref (cost=0.00..1.26 rows=26 width=11) (actual time=0.010..0.013 rows=26 loops=1)

Planning time : 1.552 ms