explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9cJ5

Settings
# exclusive inclusive rows x rows loops node
1. 0.357 72,772.422 ↑ 10,210.2 1,142 1

Subquery Scan on asdf (cost=4,063,114.51..4,705,817.65 rows=11,660,000 width=41) (actual time=46,363.427..72,772.422 rows=1,142 loops=1)

2. 9,612.400 72,772.065 ↑ 10,210.2 1,142 1

GroupAggregate (cost=4,063,114.51..4,560,067.65 rows=11,660,000 width=37) (actual time=46,363.424..72,772.065 rows=1,142 loops=1)

  • Group Key: serv_enabled.se_stcd, serv_enabled.se_rtocode, ola_mast.om_officename
3. 48,427.383 63,159.665 ↓ 1.5 36,863,800 1

Sort (cost=4,063,114.51..4,126,506.70 rows=25,356,876 width=37) (actual time=46,363.360..63,159.665 rows=36,863,800 loops=1)

  • Sort Key: serv_enabled.se_stcd, serv_enabled.se_rtocode, ola_mast.om_officename
  • Sort Method: external merge Disk: 1563264kB
4. 6,426.761 14,732.282 ↓ 1.5 36,863,800 1

Nested Loop Left Join (cost=323.73..152,337.92 rows=25,356,876 width=37) (actual time=1.551..14,732.282 rows=36,863,800 loops=1)

5. 61.226 82.025 ↓ 1.5 87,484 1

Hash Join (cost=323.44..3,104.95 rows=59,393 width=33) (actual time=1.518..82.025 rows=87,484 loops=1)

  • Hash Cond: (serv_enabled.se_rtocode = ola_mast.om_officecd)
6. 19.303 19.303 ↑ 1.0 87,997 1

Seq Scan on serv_enabled (cost=0.00..2,550.03 rows=88,003 width=13) (actual time=0.009..19.303 rows=87,997 loops=1)

7. 0.316 1.496 ↑ 1.0 1,330 1

Hash (cost=306.36..306.36 rows=1,366 width=26) (actual time=1.496..1.496 rows=1,330 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 88kB
8. 1.180 1.180 ↑ 1.0 1,330 1

Seq Scan on ola_mast (cost=0.00..306.36 rows=1,366 width=26) (actual time=0.012..1.180 rows=1,330 loops=1)

  • Filter: (((om_off_type)::text = ANY ('{R,U}'::text[])) AND ((om_postaladd4)::text = ANY ('{N,O}'::text[])))
  • Rows Removed by Filter: 694
9. 8,223.496 8,223.496 ↓ 5.3 421 87,484

Index Scan using indx_serv_enabled_history_seh_rtocode on serv_enabled_history (cost=0.29..1.71 rows=80 width=10) (actual time=0.008..0.094 rows=421 loops=87,484)

  • Index Cond: (serv_enabled.se_rtocode = seh_rtocode)
Planning time : 1.566 ms
Execution time : 72,983.399 ms