explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3IqG

Settings
# exclusive inclusive rows x rows loops node
1. 2.320 70.385 ↑ 1.3 2,627 1

Unique (cost=9,790.01..9,915.52 rows=3,347 width=145) (actual time=67.325..70.385 rows=2,627 loops=1)

2. 10.843 68.065 ↓ 1.0 3,487 1

Sort (cost=9,790.01..9,798.38 rows=3,347 width=145) (actual time=67.323..68.065 rows=3,487 loops=1)

  • Sort Key: "Contact".firstname, "Contact".lastname, "PC0".contactid, "Contact".cai, "Contact".email, "Contact".address1, "Contact".address2, "Contact".city, "Contact".state, "Contact".country, "Contact".postalcode, "Contact".phone, "Contact".secondaryphone, "PC0".contacttype
  • Sort Method: quicksort Memory: 844kB
3. 2.648 57.222 ↓ 1.0 3,487 1

Hash Join (cost=5,520.06..9,594.07 rows=3,347 width=145) (actual time=33.684..57.222 rows=3,487 loops=1)

  • Hash Cond: (("PC0".contactid)::text = ("Contact".contactid)::text)
4. 10.427 24.539 ↓ 1.0 3,493 1

Hash Join (cost=1,757.41..5,785.40 rows=3,347 width=22) (actual time=3.530..24.539 rows=3,493 loops=1)

  • Hash Cond: (("PC0".supplierid)::text = ("Supplier".supplierid)::text)
5. 10.715 10.715 ↑ 1.0 24,401 1

Seq Scan on pr_chv_data_suppliercontact "PC0" (cost=0.00..3,903.01 rows=24,401 width=27) (actual time=0.011..10.715 rows=24,401 loops=1)

  • Filter: ((pxobjclass)::text = 'CHV-Data-SupplierContact'::text)
6. 3.397 3.397 ↑ 1.0 1,362 1

Hash (cost=1,740.38..1,740.38 rows=1,362 width=5) (actual time=3.396..3.397 rows=1,362 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 66kB
  • -> Seq Scan on pr_chv_data_mastersupplier "Supplier" (cost=0.00..1740.38 rows=1362 width=5) (actual time=0.004..2.879 rows=1362loops=1)
  • Filter: (((businessunit)::text = 'SJVBU'::text) AND ((pxobjclass)::text = 'CHV-Data-MasterSupplier'::text))
  • Rows Removed by Filter: 3997
7. 14.111 30.035 ↑ 1.0 22,226 1

Hash (cost=3,484.82..3,484.82 rows=22,226 width=128) (actual time=30.035..30.035 rows=22,226 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 3075kB
8. 15.924 15.924 ↑ 1.0 22,226 1

Seq Scan on pr_chv_data_contact "Contact" (cost=0.00..3,484.82 rows=22,226 width=128) (actual time=0.005..15.924 rows=22,226 loops=1)

  • Filter: ((pxobjclass)::text = 'CHV-Data-Contact'::text)