explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 54N6

Settings
# exclusive inclusive rows x rows loops node
1. 1.028 46.353 ↑ 12.5 139 1

Unique (cost=6,888.11..6,953.10 rows=1,733 width=145) (actual time=44.995..46.353 rows=139 loops=1)

2. 4.347 45.325 ↑ 1.1 1,521 1

Sort (cost=6,888.11..6,892.44 rows=1,733 width=145) (actual time=44.994..45.325 rows=1,521 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: 369kB
3. 1.204 40.978 ↑ 1.1 1,521 1

Hash Join (cost=5,520.06..6,794.88 rows=1,733 width=145) (actual time=33.700..40.978 rows=1,521 loops=1)

  • Hash Cond: (("PC0".contactid)::text = ("Contact".contactid)::text)
4. 3.145 9.712 ↑ 1.1 1,670 1

Hash Join (cost=1,757.41..3,008.32 rows=1,757 width=22) (actual time=3.518..9.712 rows=1,670 loops=1)

  • Hash Cond: (("PC0".supplierid)::text = ("Supplier".supplierid)::text)
5. 3.067 3.067 ↑ 1.0 6,913 1

Seq Scan on pr_chv_data_contractcontact "PC0" (cost=0.00..1,207.41 rows=6,913 width=27) (actual time=0.009..3.067 rows=6,913 loops=1)

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

Hash (cost=1,740.38..1,740.38 rows=1,362 width=5) (actual time=3.499..3.500 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.964 rows=1362loops=1)
  • Filter: (((pxobjclass)::text = 'CHV-Data-MasterSupplier'::text) AND ((businessunit)::text = 'SJVBU'::text))
  • Rows Removed by Filter: 3997
7. 14.137 30.062 ↑ 1.0 22,226 1

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

  • Buckets: 32768 Batches: 1 Memory Usage: 3075kB
8. 15.925 15.925 ↑ 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.925 rows=22,226 loops=1)

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