explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Kloi : prod_poslije_prod_2

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.003 7,114.289 ↑ 5.5 2 1

Nested Loop Left Join (cost=1,002.64..93,835.68 rows=11 width=182) (actual time=7,114.259..7,114.289 rows=2 loops=1)

2. 0.005 7,114.272 ↑ 5.5 2 1

Nested Loop Left Join (cost=1,002.21..93,828.53 rows=11 width=175) (actual time=7,114.244..7,114.272 rows=2 loops=1)

3. 0.024 7,114.237 ↑ 5.5 2 1

Nested Loop Left Join (cost=1,001.78..93,735.44 rows=11 width=167) (actual time=7,114.216..7,114.237 rows=2 loops=1)

4. 0.002 7,114.173 ↑ 5.5 2 1

Limit (cost=1,001.35..93,642.38 rows=11 width=141) (actual time=7,114.160..7,114.173 rows=2 loops=1)

5. 459.714 7,114.171 ↑ 74.5 2 1

Merge Semi Join (cost=1,001.35..1,255,866.27 rows=149 width=141) (actual time=7,114.158..7,114.171 rows=2 loops=1)

  • Merge Cond: ((account.id)::text = (cmap_1.account_id)::text)
6. 2,648.672 2,648.672 ↓ 1.1 2,001,037 1

Index Scan using account_pkey on account (cost=0.43..498,687.78 rows=1,771,901 width=141) (actual time=860.523..2,648.672 rows=2,001,037 loops=1)

  • Filter: ((accountclass_code)::text = 'CP'::text)
  • Rows Removed by Filter: 2,000,608
7. 478.791 4,005.785 ↑ 49.3 6 1

Gather Merge (cost=1,000.92..752,746.67 rows=296 width=11) (actual time=4,005.390..4,005.785 rows=6 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
8. 0.000 3,526.994 ↑ 74.0 1 5 / 5

Nested Loop (cost=0.86..751,711.36 rows=74 width=11) (actual time=3,526.937..3,526.994 rows=1 loops=5)

9. 361.726 361.726 ↑ 1.2 807,904 5 / 5

Parallel Index Scan using acccontactmap_account_fk_i on acccontactmap cmap_1 (cost=0.43..196,873.18 rows=1,009,767 width=19) (actual time=0.027..361.726 rows=807,904 loops=5)

10. 3,231.617 3,231.617 ↓ 0.0 0 4,039,521 / 5

Index Scan using acccontact_pkey on acccontact contact_1 (cost=0.43..0.55 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=4,039,521)

  • Index Cond: (id = cmap_1.contact_id)
  • Filter: ((identificationno)::text ~~* '%1448285704%'::text)
  • Rows Removed by Filter: 1
11. 0.040 0.040 ↑ 1.0 1 2

Index Scan using account_pkey on account customer (cost=0.43..8.45 rows=1 width=37) (actual time=0.020..0.020 rows=1 loops=2)

  • Index Cond: ((id)::text = (account.enterprise_id)::text)
  • Filter: ((accountclass_code)::text = 'CA'::text)
12. 0.030 0.030 ↑ 1.0 1 2

Index Scan using acccontactmap_account_fk_i on acccontactmap cmap (cost=0.43..8.45 rows=1 width=19) (actual time=0.015..0.015 rows=1 loops=2)

  • Index Cond: ((account_id)::text = (account.enterprise_id)::text)
  • Filter: (((status)::text = 'ACTIVE'::text) AND ((croletype_code)::text = 'CUSTOMER_INFO'::text))
  • Rows Removed by Filter: 1
13. 0.014 0.014 ↑ 1.0 1 2

Index Scan using acccontact_pkey on acccontact contact (cost=0.43..0.65 rows=1 width=19) (actual time=0.007..0.007 rows=1 loops=2)

  • Index Cond: (id = cmap.contact_id)
Planning time : 2.116 ms
Execution time : 7,115.034 ms